| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Min function excluding zero
hi, i have a set of positive numbers (randomly generated) which includes a
zero . I want to pickout the Min from them which excludes zero. i.e, Min greater than zero. My second question is =if(or(a1=1,a1=2),"A","B")) I modified it to =if(a1={1,2},"A","B"). But This formula is true only for a1=1 any suggestions. Thank you all With regards Sridhar |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Min function excluding zero
Try one of these for the MIN:
=SMALL(A1:A10,1+COUNTIF(A1:A10,0)) Or this array formula**: =MIN(IF(A1:A100,A1:A10)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) My second question is =if(or(a1=1,a1=2),"A","B")) I modified it to =if(a1={1,2},"A","B"). But This formula is true only for a1=1 Try it like this: =IF(OR(A1={1,2}),"A","B") -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... hi, i have a set of positive numbers (randomly generated) which includes a zero . I want to pickout the Min from them which excludes zero. i.e, Min greater than zero. My second question is =if(or(a1=1,a1=2),"A","B")) I modified it to =if(a1={1,2},"A","B"). But This formula is true only for a1=1 any suggestions. Thank you all With regards Sridhar |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Min function excluding zero
Thank you Mr. Biff. It solved my problem.
With regards Sridhar "T. Valko" wrote: Try one of these for the MIN: =SMALL(A1:A10,1+COUNTIF(A1:A10,0)) Or this array formula**: =MIN(IF(A1:A100,A1:A10)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) My second question is =if(or(a1=1,a1=2),"A","B")) I modified it to =if(a1={1,2},"A","B"). But This formula is true only for a1=1 Try it like this: =IF(OR(A1={1,2}),"A","B") -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... hi, i have a set of positive numbers (randomly generated) which includes a zero . I want to pickout the Min from them which excludes zero. i.e, Min greater than zero. My second question is =if(or(a1=1,a1=2),"A","B")) I modified it to =if(a1={1,2},"A","B"). But This formula is true only for a1=1 any suggestions. Thank you all With regards Sridhar |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Min function excluding zero
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "yshridhar" wrote in message ... Thank you Mr. Biff. It solved my problem. With regards Sridhar "T. Valko" wrote: Try one of these for the MIN: =SMALL(A1:A10,1+COUNTIF(A1:A10,0)) Or this array formula**: =MIN(IF(A1:A100,A1:A10)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) My second question is =if(or(a1=1,a1=2),"A","B")) I modified it to =if(a1={1,2},"A","B"). But This formula is true only for a1=1 Try it like this: =IF(OR(A1={1,2}),"A","B") -- Biff Microsoft Excel MVP "yshridhar" wrote in message ... hi, i have a set of positive numbers (randomly generated) which includes a zero . I want to pickout the Min from them which excludes zero. i.e, Min greater than zero. My second question is =if(or(a1=1,a1=2),"A","B")) I modified it to =if(a1={1,2},"A","B"). But This formula is true only for a1=1 any suggestions. Thank you all With regards Sridhar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excluding subtotals from SUMIF function | Excel Worksheet Functions | |||
| Workday function including sat, excluding sun | Excel Worksheet Functions | |||
| Min Function Excluding Zero Values & More | Excel Worksheet Functions | |||
| Excluding 0s and blanks from a LINEST function | Excel Worksheet Functions | |||
| MIN excluding 0s | Excel Worksheet Functions | |||
Hybrid Mode
