Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking within in ranges
I need a formula that will allow me to rank one column of numbers based on a
value in another column. e.g. If I have values in column A and countries in column B. I want to rank the values by country in other words each country will have a #1 etc. also the number of values by each country will be different thanks ah |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking within in ranges
Assuming you have data in rows 2 to 100 use this formula in row 2 and copy down =SUMPRODUCT(--(A$2:A$100A2),--(B$2:B$100=B2))+1 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=532091 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking within in ranges
This was excellent
-- thanks ah "ah" wrote: I need a formula that will allow me to rank one column of numbers based on a value in another column. e.g. If I have values in column A and countries in column B. I want to rank the values by country in other words each country will have a #1 etc. also the number of values by each country will be different thanks ah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Worksheet Functions | |||
How do I find all named ranges in VB.NET? | Excel Discussion (Misc queries) | |||
Multiple Ranges for a Chart | Charts and Charting in Excel | |||
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 |