Works fine for me!!
Can you let us know what error you are getting
Regards
Michael
--
Michael Mitchelson
"One-Leg" wrote:
The formula given bellow doesn't work...
"Peo Sjoblom" wrote:
=SMALL(A1:A5,COUNTIF(A1:A5,0)+1)
--
Regards,
Peo Sjoblom
"One-Leg" wrote in message
...
Hello,
If I have a list of numbers in colum "A".
A1: 10
A2: 20
A3: 00
A4: 15
A5: 50
An I want to see in cell C2 what is the lowest number in colum that is
above
0 (in this case, it would be "10"). What do I need to put in cell C2???
Thanks!!!
|