I don't know what to tell ya!

It works for me either vertically or horizonatally.

Cells formatted as Percentage are <1 unless the percentage is =100%.

Can you post some examples and point out which values you want ranked and
which you want excluded?

Biff

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