Rank ordering dates (and repeating the command for each ID/person)

Question

I have a series of dates for each case (person) in a dataset. I am trying to rank order these dates (with duplicates) for each person.

My question is a direct application of this thread:

How to rank the date in Excel without duplicates

And I would simply like to figure out how to repeat this for over 100 cases I have in the dataset.

Example codes I have from the above thread:

=SUMPRODUCT((A$1:A$6<A1)/COUNTIF(A$1:A$6,A$1:A$6&""))+1

Now, I can I have excel repeat this code separately for each person (distinguished by ID).

Answer 1

You need to add the other criteria:

=SUMPRODUCT((($A$2:$A$13=A2)*($B$2:$B$13<B2))/(COUNTIFS($B$2:$B$13,$B$2:$B$13,$A$2:$A$13,A2)+($A$2:$A$13<>A2)))+1