Ranking with Name, Date and Time

I have a list that consist of date time and name which i want to sort or rank them based on date, time and name.
And the problem is there is some rank are the same rank but the name is different.

For Example
20/10/2019 | 9:00 PM | David rank 3
20/10/2019 | 9:00 PM | Peter rank 3

After i done my index match, my peter is not show due to index is only get the first rank 3, and it ignore the second one.
Here is the code i did:

Please Login or Register  to view this content.

Thank you,

What do you expect to see? Where do you expect to see it?

Maybe, in F3:

=AGGREGATE(15,6,($A$3:$A$17+$B$3:$B$17),ROWS($1:1))

and in G3:

=INDEX(C:C,AGGREGATE(15,6,ROW($C$3:$C$17)/($A$3:$A$17+$B$3:$B$17=F3),COUNTIF($F$3:F3,F3)))

Rather confusingly Nelson occurs twice at the same date/time in your raw data!!!

Try this, with a couple of helper colums:

The hrelpers can be on another sheet, or hidden, or both if they annoy you!!

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

Post a small sample showing the problem and your expected answer.