|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 16th, 2010, 08:13 AM
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
March 16th, 2010, 08:27 AM
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
March 16th, 2010, 08:27 AM
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
March 16th, 2010, 08:53 AM
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
March 16th, 2010, 09:15 AM
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
March 16th, 2010, 11:57 AM
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
March 17th, 2010, 12:58 AM
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  1, 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
