I need to use the rank function to get the position of each item in a list based on its corresponding Revenue. However, the range
that has the revenue numbers also contains a percentage related to that item. Basically, I need to use RANK based on a list that
ignores any elements which are <= 1. Any ideas??

Thx in advance !
--
RMC,CPA