Perhaps you'd like to try this past gem by Daniel M at:
http://tinyurl.com/3gmdv

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"lightninbug" wrote in message
...
I searched for all posts regarding rank formulas and did not see exactly
what
I was looking for. Here is what I need to do - Rank by dollar values, some
of
these values are zero and do not need to be included in the ranking or can
be
ranked zero. Also, if there are duplicate values they need to be given
separate consecutive ranking. Got any ideas/ Thanks