Hi, I found this formula very helpful, but how can I make it to work in a
conditional formating ?Gives error.

array - enter with control+shift+enter
=MIN(IF(C1:C100,C1:C10))


"OkieViking" wrote:

No, not for me anyway. This is for work.

Thanks

"Don Guillett" wrote:

This question seems to be going around today. Homework?

non array enter with enter only
=SMALL(C1:C10,COUNTIF(C1:C10,0)+1)

array - enter with control+shift+enter
=MIN(IF(C1:C100,C1:C10))


--
Don Guillett
SalesAid Software

"OkieViking" wrote in message
...
I have a table populated with equations. I need to write a function to
find
the smallest value in that table. However, I want to ignore the zero
values.
From a dataset containing 8, 5, 0, 7 I want to find 5, not zero.

How do you do that?