View Single Post
  #1   Report Post  
Brenda Rueter
 
Posts: n/a
Default MIN with zero values in the range

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!