Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default find smallest positive number among datas

How to find the smallest positive number among datas in Excel?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 834
Default find smallest positive number among datas

Try

=MIN(data_rng)

--

HTH

Bob

"Cerberus" wrote in message
...
How to find the smallest positive number among datas in Excel?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default find smallest positive number among datas

=MIN(IF(A1:A60,A1:A6)) as an array formula (Control Shift Enter)
Adjust your range to suit.
--
David Biddulph


"Cerberus" wrote in message
...
How to find the smallest positive number among datas in Excel?



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default find smallest positive number among datas

Try the below to return the max positive from Col A

=MAX(0,A:A)

--
Jacob


"Cerberus" wrote:

How to find the smallest positive number among datas in Excel?

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default find smallest positive number among datas

I have misread your post..Refer the post from David...

--
Jacob


"Jacob Skaria" wrote:

Try the below to return the max positive from Col A

=MAX(0,A:A)

--
Jacob


"Cerberus" wrote:

How to find the smallest positive number among datas in Excel?



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 42
Default find smallest positive number among datas

Non Arrary forumula,

=SMALL(A1:A5,COUNTIF(A1:A5,"<0")+1)
Adjust your range to suit.

Vijay

"David Biddulph" wrote:

=MIN(IF(A1:A60,A1:A6)) as an array formula (Control Shift Enter)
Adjust your range to suit.
--
David Biddulph


"Cerberus" wrote in message
...
How to find the smallest positive number among datas in Excel?



.

  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,766
Default find smallest positive number among datas

Hi,

You may also try this. Suppose the data is in range A2:A60. In A1, type
the heading, say Amount. In C1:D1, type Amount (copy from cell A1). In C2,
type 0. In D2, type =dmin($A$1:$A$60,D$1,C$1:C2)

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Cerberus" wrote in message
...
How to find the smallest positive number among datas in Excel?


Reply
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
Visual Script to find smallest number greater than 0 Jeremy Excel Discussion (Misc queries) 3 October 30th 09 09:32 PM
Smallest positive value danpt Excel Discussion (Misc queries) 2 April 29th 09 02:22 AM
Find X number of smallest values in a range Steve Haack Excel Worksheet Functions 1 August 14th 07 05:02 AM
find smallest number not equal to 0 dave Excel Worksheet Functions 2 April 20th 05 10:56 PM
The formula to find the smallest number in a row not equal to zero seastheday Excel Worksheet Functions 8 April 14th 05 11:58 PM


All times are GMT +1. The time now is 08:05 PM.

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

About Us

"It's about Microsoft Excel"