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!