Thread: Ranking by type
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steven Cheng Steven Cheng is offline
external usenet poster
 
Posts: 28
Default 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.