| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I select & use contents of first non-blank cell in row?
I've got 12 columns (headed Jan - Dec), each of which contains a combination
of numerical & blank cells. For each row, I want to select the first non-blank cell and return the column header that it lies in e.g. Row 1, first non-blank cell is in the Apr column, so I want the text "Apr" to be returned to another cell. Help please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If cell is blank, then cell is red | New Users to Excel | |||
| Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
| Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
Threaded Mode
