Duplicates by seniority

**Shadmani** · 04-01-2011, 02:48 AM

Hi,

I have a list of students with their date of birth.

I need to identify identical names. If their Date of birth is different, I need to name as below..

First name - First
second identical name - second
Third identical name - Third & so..

For example...

If I have 3 peters in my class... DOB as 12.12.90, 13.12.90, 14.12.90

Peter with 12.12.90 - should be 1st
Peter with 13.12.90 should be 2nd
Peter with 14.12.90 - should be 3rd...

I use teh duplicate formula as below...
=IF(COUNTIF($D$2:$D3,D3)=1,"first","dupes")..may be slight modification required on this..

If you are not clear, please let me know, I will send the excell.

Thanks
Shadmani

**Palmetto** · 04-02-2011, 12:32 PM

Why not just sort the data:

1. Level-1 sort: dates in ascending order
2. Level-2 sort: names in ascending order

**Shadmani** · 04-09-2011, 10:29 AM

Hi,

Yes. I can sort. But how will name them based on seniority ?
There may be 3 Peters, 2 Sams, 5sara etc.,
I need to give them as First, Second, Third etc., ?

Thanks

**Palmetto** · 04-09-2011, 12:13 PM

Post a workbook showing a "before" and "after" examples, and include a clear explanation of all criteria, etc, to help with the logic of developing the solution.