|
|
|
|
#1
04-06-2019, 11:32 PM
|
|||
|
|||
@NoSparks
... populating C1 to V1 as it misses the second year shown in A1 .... You are right. ´ The formula in C1 should just be copied to D1:V1 and it works. I don't know what has happened. Last edited by xor; 04-07-2019 at 01:44 AM. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula to Extract text from a text string | Haha88 | Excel | 2 | 11-14-2017 01:32 AM |
| How to assign numbers to letters and then create a formula to add them together for a rota | Mskapri | Excel | 6 | 04-01-2017 03:05 PM |
 I'm looking for a formula to extract all the text before the last name in a cell
|
Gef | Excel | 4 | 02-01-2015 07:14 PM |
| Word not 'rounding' letters up to word in next line (parents and orphans) | Asa | Word | 4 | 09-13-2014 06:47 PM |
| extract text with formula | s7y | Excel | 7 | 06-05-2013 06:18 AM |
Windows 10 
Office 2016
Hybrid Mode