LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 65
Default find first positive number in column

I have a column of figures, maximum of 7 numbers in total and need to find
the first positive number in the column, negatives will always be shown first
and are dependant on other calculations. Some of the last cells may be blank
depending on the periods in the term ie
1. -10
2. -1
3. 10
4. 5
5. 80
6.
7.
Should return 10 as the first positive in the list
Is there a built in fucnction I can use to do this? Many thanks for any help

Sheila D

 
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
How to find what number in Column A is not included in Column B? Zhi Sheng Excel Discussion (Misc queries) 2 September 1st 08 02:42 AM
Find first positive value in a column George Excel Discussion (Misc queries) 5 October 27th 07 06:20 PM
Find max Row() number for a value in column Vlado Sveda Excel Worksheet Functions 12 January 20th 07 05:32 PM
FIND POSITIVE VALUE FIRSTROUNDKO via OfficeKB.com Excel Discussion (Misc queries) 2 March 23rd 06 01:43 AM
How do I find the first value in a column less than a number? redeucer Excel Worksheet Functions 6 November 4th 04 09:59 PM


All times are GMT +1. The time now is 11:22 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"