Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup based on 1st non-blank cell
This should be easy but I'm having problems. Data looks like this.
Jan Feb Mar Apr.........Dec John 10 5 6 Mary 2 4 Jill 5 1 5 I want to add a column that will find the first non-blank cell after the name and then return the column header to that cell so it looks somethng like this. Name Start John Feb Mary Mar Jill Jan And if there is never a non-blank cell I'd like it to return N/A. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count with multiple criteria based on cell not blank? | Excel Worksheet Functions | |||
Function to give value of a BLANK cell based on another | Excel Worksheet Functions | |||
Returning a blank cell rather then #N/A (Lookup) | Excel Discussion (Misc queries) | |||
Return of blank cell if lookup fails | Excel Worksheet Functions | |||
Lookup with search range start based on position of last blank lin | Excel Worksheet Functions |