| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS | Excel Worksheet Functions | |||
| How to return the last non-blank cell in a column that is TEXT | Excel Worksheet Functions | |||
| Formula to return position of the next Non-blank cell in a column | Excel Worksheet Functions | |||
| Return next non-Blank Cell in a Column ? | Excel Worksheet Functions | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
Threaded Mode
