Share via

Min Function Not including "0"

Anonymous
2015-11-23T20:16:55+00:00

Simple Question (I Think):

Trying to use the MIN Function, but do not want it to include 0.

Example: Have 5 Numbers: 10, 8, 6, 15,0.  Trying to find a formula to give me the smallest number but not include the 0.

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-11-24T10:36:46+00:00

yet another alternative:

=SUMPRODUCT(MIN(1E+100*(A1:A5=0)+A1:A5))

Was this answer helpful?

0 comments

Answer accepted by question author

Vijay A. Verma 104.9K Reputation points Volunteer Moderator
2015-11-24T07:54:09+00:00

An alternative formula -

=AGGREGATE(15,6,A1:A5/(A1:A5<>0),1)

Was this answer helpful?

0 comments

Answer accepted by question author

Anonymous
2015-11-23T20:36:30+00:00

Hi,

assuming that 5 numbers are in cells A1:A5

in cell B1 write

=IF(MIN(A1:A5)<>0,MIN(A1:A5),SMALL(A1:A5,COUNTIF(A1:A5,0)+1))

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-11-23T20:42:18+00:00

    Array formula.

    =MIN(IF($A$1:$A$10 <>0,$A$1:$A$10))

    Enter using CRTL + SHIFT + ENTER

    Gord

    Was this answer helpful?

    0 comments