View Single Post
  #6   Report Post  
OkieViking
 
Posts: n/a
Default

The cells I am looking at are all on one row, but every other column. How do
I make the below work?

"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?