View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tckok56
 
Posts: n/a
Default To Rank on two Criteria

Thanks again to rsenn
Also to all excelforum.com members who can help.

Below is a sample of data. The 3rd column is what I wish to arrived at using
a RANK function. Column A is sorted in ascending order first before column B
is considered so as to avoid having two or more rows with the same ranking.

GRADE AV RANK
POINT
-------- --------- --------
5.00 14.9 11
1.25 84.8 2
1.25 83.9 3
1.00 84.3 1
2.00 52.2 6
1.88 74.3 4
1.88 73.6 5
3.20 56.3 9
2.10 51.4 7
2.10 51.0 8
4.30 40.2 10

Can I have a RANK function to solve my problem?
Thank you
--
May the force be with you!