| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return next non-Blank Cell in a Column ?
Is there a way to link to non-blank cells? For example, if A1 through A10
contained: a1: John a2: a3: Mary a4: Jane a5: a6: a7: Alice a8: a9: Martha a10: George a1: John a2: a3: Mary a4: Jane a5: a6: a7: Alice a8: a9: Martha a10: George then the formulas in B1 through B6 would give: John Mary Jane Alice Martha George -- jake |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| If cell blank return a blank | Excel Worksheet Functions | |||
| Return a value to a cell that is blank | Excel Discussion (Misc queries) | |||
| return a blank cell | Excel Worksheet Functions | |||
| use IF to return a truly blank cell | Excel Discussion (Misc queries) | |||
Threaded Mode
