ranking by two variables

Hi,

I need to rank some data and donor ID.
I know how to rank by one variables but I can't seem to get the correct results when I try and rank by two.

This is an example of the date I'm working with

Date.................ID
1/2/2013............A
1/10/2013..........B
2/2/2013............D
2/2/2016............C
2/3/2012............B
3/3/2013............D
4/1/2013............C
4/2/2013............C
6/15/2013...........A
4/2/2014............B
4/2/2014............D
10/30/2014.........A
10/15/2015.........B
10/16/2015.........C
8/8/2016............C


I want to be able to rank by ID and date
example:

Date.................ID.......Rank
1/2/2013............A.........1
1/10/2013..........B.........2
2/2/2013............D.........1
2/2/2016............C.........3
2/3/2012............B.........1
3/3/2013............D.........2
4/1/2013............C.........1
4/2/2013............C.........2
6/15/2013..........A.........2
4/2/2014............B.........3
4/2/2014............D.........3
10/30/2014.........A.........3
10/15/2015.........B.........3
10/16/2015.........C.........4
8/8/2016............C.........5


Is this something can be done?


Thanks!

Try this ...

=COUNTIFS($A$2:$A$16,"<"&A2,$B$2:$B$16,B2)+1

Originally Posted by Phuocam

Try this ...

=COUNTIFS($A$2:$A$16,"<"&A2,$B$2:$B$16,B2)+1

Hi Phuocam, this formula is good if no duplicate entry. But the below formula deals with duplicates also.

Please Login or Register  to view this content.