Return last non-blank cell in column

[laurawolfgang]

Hi all,

I am trying to write an IF statement that returns all non-blank cell
one column over, and if blank, returns the previous non-blank cell i
that column. For example:

A B
1 Apple
2 Orange
3 Strawberry
4
5
6 Grapefruit
7 Banana
8
9 Blueberry

I would like column C to return the following:

C
Apple
Orange
Strawberry
Strawberry
Strawberry
Grapefruit
Banana
Banana
Blueberry

Any thoughts?

Thanks in advance

 

[Ron Rosenfeld]

Hi all,

I am trying to write an IF statement that returns all non-blank cells
one column over, and if blank, returns the previous non-blank cell in
that column. For example:

A B
1 Apple
2 Orange
3 Strawberry
4
5
6 Grapefruit
7 Banana
8
9 Blueberry

I would like column C to return the following:

C
Apple
Orange
Strawberry
Strawberry
Strawberry
Grapefruit
Banana
Banana
Blueberry

Any thoughts?

Thanks in advance!

C1: =LOOKUP(2,1/(LEN($B$1:B1)>0),$B$1:B1)

Fill down as far as required.

 

[laurawolfgang]

Perfect. Thanks so much!

;1610706']On Wed, 27 Mar 2013 21:51:13 +0000, laurawolfgan

Hi all,

I am trying to write an IF statement that returns all non-blank cells
one column over, and if blank, returns the previous non-blank cell in
that column. For example:

A B
1 Apple
2 Orange
3 Strawberry
4
5
6 Grapefruit
7 Banana
8
9 Blueberry

I would like column C to return the following:

C
Apple
Orange
Strawberry
Strawberry
Strawberry
Grapefruit
Banana
Banana
Blueberry

Any thoughts?

Thanks in advance!-

C1: =LOOKUP(2,1/(LEN($B$1:B1)>0),$B$1:B1)

Fill down as far as required

 

[Ron Rosenfeld]

Perfect. Thanks so much!

Glad to help. Thanks for the feedback.