Ranking values within groups of duplicates

Hi mbf123- Welcome to Excel Help Forums! This sounds pretty doable. If you attach a small sample workbook to your post, you'll get more responses. Remove any sensitive or extraneous info, just show us where your data is, what your results should look like (mock-up) and where you want them. Thanks-Lee

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now just Browse for your file, then click Upload. Simple!

Try this formula. Paste in C1 and copy down:
=COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,"<"&B2)+1

The data shown below is sorted for easy verification, but the formula works with any order.

Row\Col	A	B	C
1	Name	Date	Rank
2	aaa	5/11/2017	1
3	aaa	5/22/2017	2
4	aaa	6/5/2017	3
5	bb	4/29/2017	1
6	bb	5/10/2017	2
7	dd	5/26/2017	1
8	dd	6/1/2017	2
9	ee	5/19/2017	1
10	ee	6/8/2017	2

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee