I couldn't get that to work in my spreadsheet. My list is in row 6 and is horizontal. The list contains elements which are both
percentages and integers. I need to rank the integers only and ignore the percentages. The sumproduct example gave a couple of close
answers but none were correct (I adjusted for the horizontal list and for using the correct element instead of "A1").
--
RMC,CPA


"Biff" wrote in message ...
Hi!

Try this:

Range to rank is A1:A20

Enter this formula in B1 and copy down to B20:

=IF(A11,SUMPRODUCT(--($A$1:$A$201),--(A1<$A$1:$A$20))+1,"")

Biff

"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