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)?
