Return last non-blank cell in column
 

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!

Return last non-blank cell in column
 

On Wed, 27 Mar 2013 21:51:13 +0000, laurawolfgang wrote:


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.

Perfect. Thanks so much!

Return last non-blank cell in column
 

On Thu, 28 Mar 2013 14:59:22 +0000, laurawolfgang wrote:

Perfect. Thanks so much!

Glad to help. Thanks for the feedback.