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!

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

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

"Lisa" wrote:

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!

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.

"Eduardo" wrote:

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

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

"Lisa" wrote:

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!

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

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

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

"Lisa" wrote:

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!

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" wrote:

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.

"Eduardo" wrote:

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

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

"Lisa" wrote:

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!

Select column A.

F5SpecialBlanksOK

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 SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Wed, 31 Dec 2008 10:44:03 -0800, Lisa
wrote:

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!

And copy the second formula all the way down

"Eduardo" wrote:

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" wrote:

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.

"Eduardo" wrote:

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

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

"Lisa" wrote:

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!

Rock out dude! Thanks so much!

Thanks for all help! :)

"Gord Dibben" wrote:

Select column A.

F5SpecialBlanksOK

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 SpecialValuesOKEsc


Gord Dibben MS Excel MVP

On Wed, 31 Dec 2008 10:44:03 -0800, Lisa
wrote:

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!