add consecutive number for each individual with multiple rows per person

Hi

I have a file that contains multiple rows per individual, each with a different date.

I'd like to allocate a consecutive incrementing number for each individual, like the 'time' column below. This is just a one-off thing I need to apply to this dataset to allow further analysis - doesn't need to be dynamic.

I'm unable to attach a file but below is how the data looks (my file has approx 1k records, 200 ID codes). There is unique identifier for each 'person' but a varying number of rows for each person. It's already sorted by ID and date, so the date variable doesn't need to be used. I would like to find a way for excel to add the 'time' column.
E.g.

ID. date. time
ID1 -- 3/apr/15. 1
ID1 -- 5/june/16. 2
ID1 -- 2/mar-17. 3
ID2 -- 1/jan/13. 1
ID2 -- 5/mar/15. 2

I feel that there should be a simple way to do this but am struggling to formulate the question. I'd be very grateful for any tips on how to achieve this. Thank you for reading!

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

You could try this in C2 copied down:

=COUNTIF(A$2:A2,A2)

Glad to have helped.

If you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Megavic. DO NOT do this again. One more thread hijacking and you will get a one week ban from this site.

Kindly READ the forum rules that you agreed to obey:

https://www.excelforum.com/forum-rul...um-rules2.html

Aas already requested, start your OWN thread.

NO HELP to be offered to Megavic at Post 5.