Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking by type
i have a list of items that need to be rank by type. example:
col A Col b Col c Item # Type 1 A 89% 2 B 78% 3 B 66% 4 C 77% 5 A 78.8% 6 C 67% etc.. of course the list is a little longer but continguous. i want to have rankings ascending by value in column C and by Type (column B). So, Item 5, would be ranked #1 out of the A pool and item 1 would be #2 in A pool. if someone could help me out that would be greeat. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking by type
Try this:
=SUMPRODUCT(--(B$2:B$7=B2),--(C2C$2:C$7))+1 Copy down as needed -- Biff Microsoft Excel MVP "Steven Cheng" wrote in message ... i have a list of items that need to be rank by type. example: col A Col b Col c Item # Type 1 A 89% 2 B 78% 3 B 66% 4 C 77% 5 A 78.8% 6 C 67% etc.. of course the list is a little longer but continguous. i want to have rankings ascending by value in column C and by Type (column B). So, Item 5, would be ranked #1 out of the A pool and item 1 would be #2 in A pool. if someone could help me out that would be greeat. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking by type
What does the -- mean or do?
"T. Valko" wrote: Try this: =SUMPRODUCT(--(B$2:B$7=B2),--(C2C$2:C$7))+1 Copy down as needed -- Biff Microsoft Excel MVP "Steven Cheng" wrote in message ... i have a list of items that need to be rank by type. example: col A Col b Col c Item # Type 1 A 89% 2 B 78% 3 B 66% 4 C 77% 5 A 78.8% 6 C 67% etc.. of course the list is a little longer but continguous. i want to have rankings ascending by value in column C and by Type (column B). So, Item 5, would be ranked #1 out of the A pool and item 1 would be #2 in A pool. if someone could help me out that would be greeat. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Ranking by type
See these:
http://xldynamic.com/source/xld.SUMPRODUCT.html http://mcgimpsey.com/excel/formulae/doubleneg.html -- Biff Microsoft Excel MVP "Ranking by type, and the dashes" <Ranking by type, and the wrote in message ... What does the -- mean or do? "T. Valko" wrote: Try this: =SUMPRODUCT(--(B$2:B$7=B2),--(C2C$2:C$7))+1 Copy down as needed -- Biff Microsoft Excel MVP "Steven Cheng" wrote in message ... i have a list of items that need to be rank by type. example: col A Col b Col c Item # Type 1 A 89% 2 B 78% 3 B 66% 4 C 77% 5 A 78.8% 6 C 67% etc.. of course the list is a little longer but continguous. i want to have rankings ascending by value in column C and by Type (column B). So, Item 5, would be ranked #1 out of the A pool and item 1 would be #2 in A pool. if someone could help me out that would be greeat. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to convert date type to text type | Excel Discussion (Misc queries) | |||
Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
Excel will not let me type any characters....I can type in Word. | Excel Discussion (Misc queries) | |||
how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) | |||
Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) |