Forum Discussion
How to fill empty cells with a sequence of numbers?
I have been facing this problem for a long time. Sometimes i get excel files that only some of cells have value and i need to fill empty cells with sequence of numbers. for example see following...
IMHO you have to explain how you calculate your suitable numbers. With a logic that's probably wrong I can reconcile some numbers (a variance of 0.5 in column H though):
and following your calculation logic what would be the suitable numbers in the yellow cells?
AND What version of Excel do you run + on which OS (Windows / Mac)?
If the number trend is upward : 42500 - 42000 = 500 one empty cell between them then 500/2 = 250
If there is a blank between two cells and both cells are the same = fill all empty cells with same numbers. for example in your screenshot all yellow cells must fill with 48533
If the number trend is downward : like cells between FK25 and FO25 then 463667 - 448284 = 15383 there are 3 empty cells between that then 15383/4 = 3845 and cells must fill like : 463667,459822,455977,452132,448284
If there is a blank between two cells and both cells are the same = fill all empty cells with same numbers. for example in your screenshot all yellow cells must fill with 48533
If the number trend is downward : like cells between FK25 and FO25 then 463667 - 448284 = 15383 there are 3 empty cells between that then 15383/4 = 3845 and cells must fill like : 463667,459822,455977,452132,448284