| 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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
Perfect. Thanks so much!
Quote:
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| 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 | |||
Linear Mode
