| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I have a list of data, fill in the gaps. FILL function won't work
I have a list of data in which I would like to fill in the gaps. Is this
possiable? I have age in years in A2 to A100 then data in colums in 5 year gaps (eg B2 has data then B7 then B12 etc) all incremental. I would like to fill in the gaps belween giving me data B2, B3, B4... to B100. How can I fill in the gaps whilst still making sure my 5 year results are left. Simple example below age Result 45 20 46 47 48 49 50 30 51 52 53 54 55 50 Many Thanks for any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Expanding Data validation from List | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| How do I get LIST on the DATA menu bar-I need Create List | New Users to Excel | |||
| Data Validation - Dropdown List Not Appearing | Excel Discussion (Misc queries) | |||
| How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
Threaded Mode
