Hi Excel gurus!

Not really sure if my title describes the issue I have in a good way, as I am not sure how to phrase it.

I'll try my best to explain it here.

I have a table which looks like this:

Name 1 IDNumber Name 2 Name 3 Column 5

Tom 20148 John Malmo
Tom 20148 Will Malmo
Bob 20206 Will Malmo
Tom 20206 Will Paris
Bob 20206 Rob Rotterdam
Bob 20207 John Rotterdam
Ray 20207 John Paris
Tom 20208 John Malmo
Ray 20208 Rob London
Ray 20209 Rob Paris
Bob 20209 Will Malmo

Is it possible to have excel go through this list and assign each row a number in column 5 based on the names and the IDNumber? Basically, I would want each entry that is identical in name 1, 2 and 3 to be assigned numbers 1, 2, 3, 4, 5 etc based on their IDNumber. So Tom/John/Malmo with the IDNumber 20148 would get the number 1 in column 5, while the next match (Tom/John/Malmo/20208) would get the number 2 in column 5. For each different match of Name 1,2 and 3, I would want the count in column 5 to start at 1. So Bob/Will/Malmo/20206 would get number 1, Bob/Will/Malmo/20209 number 2 etc.

I hope this made sense. If not, I'll try to clarify.

Thanks!

Andy

PS: I know the columns are a bit cramped together. Not sure how to fix. Hopefully you understand the layout.