Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find smallest positive number among datas
How to find the smallest positive number among datas in Excel?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Script to find smallest number greater than 0 | Excel Discussion (Misc queries) | |||
Smallest positive value | Excel Discussion (Misc queries) | |||
Find X number of smallest values in a range | Excel Worksheet Functions | |||
find smallest number not equal to 0 | Excel Worksheet Functions | |||
The formula to find the smallest number in a row not equal to zero | Excel Worksheet Functions |