Ken, I'm afraid I don't follow the "array" part and Ctrl+Shieft+Enter. Can
you elaborate? I also do not understand what the IF statement is doing in
this formula, but I would like to understand it.

"Ken Wright" wrote in message
...
=MIN(IF(A1:A100,A1:A100))

array entered using CTRL+SHIFT+ENTER

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

--------------------------------------------------------------------------
--
It's easier to beg forgiveness than ask permission :-)
--------------------------------------------------------------------------
--

"Brenda Rueter" wrote in message
...
How do I get the minimum number in a range EXCLUDING ZEROS? I have a
range
and some cells in the range have a zero balance. MIN ordinarily would
be
zero, but I want the next smaller number. So far I do not have a clue
on
how to get there. TIA!