they will be flexible enough to move the extra garbage
out of the way and let the function work as designed

Yep, a "good" design can save all kinds of headaches!

However, the fact is, Rank is not a very fexible function!

Biff

"R. Choate" wrote in message
...
I got a solution in another forum that was very simple but apparently not
as simple as my brain. It has a flaw in that it will not
work correctly if 2 or more audit fees (the integers) are identical.
However, I was doing the research on this for someone else who
doesn't have a clue, and who informed me that there will never be 2
identical audit fees on the worksheet. With that info, I used
the simple solution and called it a day. I appreciate your help very much.
If I thought this situation was likely to come up again,
I would send you the answer they provided for me. However, most of the
time, if a person needs a rank, they will be flexible enough
to move the extra garbage out of the way and let the function work as
designed instead of making employees jump through
time-consuming hoops just to allow them to keep percentages on the same
row as the data being ranked. In any case, I have moved on
and deleted the file from my PC (after sending it back to the person with
the problem).

Thanks again !

Richard
--
RMC,CPA


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