LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default How to find the first non-blank number in a row?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find First Non blank cell than find column header and return that value Silver Rose Excel Worksheet Functions 10 April 30th 07 05:56 PM
countif formula to find the occurances of a number that is greater than one number but less than another steveo Excel Discussion (Misc queries) 3 July 8th 06 02:04 AM
VBA Find Next Available Blank Rows [email protected] Excel Discussion (Misc queries) 2 April 5th 06 07:30 PM
Find second blank row singlgl1 Excel Discussion (Misc queries) 2 November 26th 05 05:44 PM
How do I find cells that being with a blank? bvinternet Excel Discussion (Misc queries) 3 July 23rd 05 09:25 PM


All times are GMT +1. The time now is 01:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"