Rank(A1,C1:C5) - Rank using 2 ranges

[Guest]

I've found that when using the Rank function, the value you want to rank has
to be in the range of values you're comparing it to. That is why the
following formula doesn't work:
=Rank(A1,C1:C20)

What I'm trying to do is see how where something would rank if it was part
of another data set. Is there a way to accomplish this using some kind of
array formula?

Jeff

 

[Guest]

this seemed to work for me

=RANK(A1,(C1:C20,A1))

 

[Guest]

Thanks! That worked like a charm.

this seemed to work for me

=RANK(A1,(C1:C20,A1))

 

[Guest]

you're welcome. thanks for the feedback.

Thanks! That worked like a charm.