Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Worksheet Functions | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |