Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have several rows which all start out as blank cells but then over time
start to have numbers (though the numbers start to come at different times). I would like to write a formula that pulls the first non-blank cell for each row. The numbers (once they start) are not sequential so i cannot use a min/max function. There are also sporadic blanks which poses another hurdle. For example: A B C D E Row 1. 15 11 23 2. 21 12 17 3. 2 4 78 65 13 4. 18 12 The formula i would like to write would result in the following: 1. 15 2. 21 3. 2 4. 18 I would assume there is a function that says "Return me the number in the first cell in this row that is greater than 0"...I just cannot figure it out. Please advise. THANKS!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
VBA Find Next Available Blank Rows | Excel Discussion (Misc queries) | |||
Find second blank row | Excel Discussion (Misc queries) | |||
How do I find cells that being with a blank? | Excel Discussion (Misc queries) |