What do you mean by overlook zeroes?
An example might help.
Does this do what you want?
=IF(J1=0,"",RANK(J1,$J$1:$J$73,1)-1)
--
tj


"JA" wrote:

Is it possible to set the "rank" formula to overlook zeros?