I'm sure there is such an easy answer to this but I can't for the life of me
right now figure it out...

I have two results in column C, 80% in row 22 and 90% in row 32. In column D
22 & 32 I need to rank these two and I want to set up a formula to do so as
it will be used on a monthly basis. What formula can I use to rank these two
numbers? I've tried the normal ranking formula and it doesn't seem to work
what how I am trying it when skipping cells. I would think the IF formula
would work but I'm not too familiar with it and cannot seem to find the
calculation that works.

try:

=Rank(c22,c22:c23,0)

--
Regards,
Fred


"casdaq" wrote in message
...
I was trying... =Rank(c22,c22,c23,0) which I knew was wrong.

I think I've figured it out though, not sure why it took me asking here to
have it come to me :0)

This formula seems to work... =Rank(c22,(2cc,c23),0)

Thank you anyways.


"Teethless mama" wrote:

Post your formula.


"casdaq" wrote:

I'm sure there is such an easy answer to this but I can't for the life of
me
right now figure it out...

I have two results in column C, 80% in row 22 and 90% in row 32. In column
D
22 & 32 I need to rank these two and I want to set up a formula to do so as
it will be used on a monthly basis. What formula can I use to rank these
two
numbers? I've tried the normal ranking formula and it doesn't seem to work
what how I am trying it when skipping cells. I would think the IF formula
would work but I'm not too familiar with it and cannot seem to find the
calculation that works.