Send me your file:

xl can help at comcast period net

Remove "can" and change the obvious.

Biff

"R. Choate" wrote in message
...
Another person came up with a formula that is close to working. I am
writing because I neglected to mention a fact about my WS which
I didn't consider relevant. There is a blank column between each integer
and associated %, then another blank column before the next
company to the right. In his solution, the blank columns made a big
difference. Biff's solution still wouldn't work for me though,
even when I deleted the extra columns
--
RMC,CPA


"R. Choate" wrote in message
...
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