sai wrote:
Frank,

Thank you so much. Works !!!

Sai

I had to modify the function by adding a ROUND function in order for it
work properly. Excel was not calculating an exact FALSE (i.e., zero)
value in some cases:

=ROUND(MOD(SUMPRODUCT(($A$1:$A1<"")/(COUNTIF($A$1:$A1,$A$1:$A1)+($A$1:$A$1=""))),2),0)

Still, it's an elegant solution I wouldn't have thought of.
Glenn Ray
MOS Master