Autofilling values UPWARDS

[SEO]

Hi!

Does anyone have a solution on how to fill a value upwards until a new value appears? (and then repeating the procedure after the new value)

I know this can be done downwards with "find -> blanks, entering a formula and then ctrl+enter" but I cant figure out how to make it work upwards.

I have tried using an IF formula, but i cant get it to function. The IF function was set up like this: in Cell S129 (first data entry is in S130, and I want that value to be repeated up to S2) =IF(ISBLANK(S129);S130;S129). This results in a 0,00 in S129 (I know it's a circle definition on the value_if_false part, but I allowed it and it's the only way I could figure out to not overwrite the next new value). So my problem here is that the formula returns the zero value which is not the value in S130.

I also figured that if I could "mirror" the column so that my last cell (S8112) becomes my first cell (S2) I could fill it downwards and the "flip" it back again.. Any suggestions on how to do that?

I hope any of you can help on this matter

Regards, SEO

 

[VoG]

Select the data, press F5, click Special, tick Blanks and click OK.

Press =

Press Down arrow

Press CTRL + Enter.

 

[SEO]

I realise now I should have thought about the myself

But, still - Many thanks for the help and the quick reply