![]() |
#4
|
||||
|
||||
![]()
Simpler still:
=MIN(IF(($A$1:$A$6<>0)*($A$1:$A$6<>1),$A$1:$A$6)) or, if you can only have integers of 0 or more: =MIN(IF($A$1:$A$6>1,$A$1:$A$6)) either as an array formula.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|