Help! Minimum Excluding zeros across multiple sheets
Yes I1 to I14, maybe I wasn't the best range to choose
this is better and cannot be misunderstood
H1:H14
Although you might want to look at Harlan's solution, he is correct that
a non volatile formula is to be preferred when possible.
--
Regards,
Peo Sjoblom
wrote in message
...
The first one worked GREAT - thank you very much...
I kept getting a REF error when using the one with the range. Was
that supposed to be an 'i' (letter i) in front of the sheet ranges?
Thanks again...
|