Copy value from cell above

[Lisa]

Hello.

In this particular spreadsheet, I have a value (an ID #) in A2.
However...A3, A4, and A5 are blank. A6 starts over with another unique ID
number.

I need the ID number to appear in every cell in the column. For example: if
A2 value is 445...I want A3 A4 and A5 to show 445. Then, when A6 changes to,
say, 778, I want A7 A8 and A9 to show 778. The reason is because I need to do
a v-lookup for data in column I5 (etc). Using the auto-fill from the corner
of each A2, A6 cell is too time consuming as the spread is huge.

Is there a formula that will do this for the whole column? Thanks much!

 

[Eduardo]

Hi Lisa
in column B enter this formula and copy all the way down, it will do the trick

=+IF(A2="",A3,A4)

 

[Lisa]

This is getting closer. That formula is returning a zero in B2, B3 and B4,
then B5 is showing the value in B6.

I hope I'm explaining this right. I need A3, A4 and A5 to match A2
(substitute B for A for new column.)

Apologies if I am being dense.

 

[David Biddulph]

But please leave out the + sign, which is totally unnecessary.

 

[Eduardo]

Ok, I found a mistake in what I sent to you, but still I don't understand why
you get 0 in B2, please check that in column A are #
You said that in A2 you have 445, so if you enter this formula in B2
=if(A2="",A1,A2), this will bring 445, then in B3 you have to enter the
formula as follow

=if(A3="",B2,A3)

 

[Gord Dibben]

Select column A.

F5>Special>Blanks>OK

Type an = sign in active blank cell then point or arrow to cell above.

Hit CTRL + ENTER

You then copy the column and in place Paste Special>Values>OK>Esc


Gord Dibben MS Excel MVP

 

[Eduardo]

And copy the second formula all the way down

Ok, I found a mistake in what I sent to you, but still I don't understand why
you get 0 in B2, please check that in column A are #
You said that in A2 you have 445, so if you enter this formula in B2
=if(A2="",A1,A2), this will bring 445, then in B3 you have to enter the
formula as follow

=if(A3="",B2,A3)

 

[Lisa]

Rock out dude! Thanks so much!

Thanks for all help!