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

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

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

this seemed to work for me

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

"goofy11" wrote:

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

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

Thanks! That worked like a charm.

"JMB" wrote:

this seemed to work for me

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

"goofy11" wrote:

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

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

you're welcome. thanks for the feedback.

"goofy11" wrote:

Thanks! That worked like a charm.

"JMB" wrote:

this seemed to work for me

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

"goofy11" wrote:

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