Originally Posted by Roger Govier

Hi
Try
=IF(COUNTIF(A:A,"=0")=COUNT(A:A),0,A1/(SMALL(A:A,COUNTIF(A:A,"=0")+1)))
--
Regards

Roger Govier


"zealot" wrote in message
...

thanks!!!!

I have an additional question…do you know how to make this
formula to give off a zero if all the FILLED cells in a list are equal
to 0. for example

When the list is as follows

0%
0%
0%
0%

Or

0%
0%
0%

or

0%

Thanks a lot!!!!!!!!!!!!!!


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
zealot