A simple table has four columns: ID number, Name, Year, Time.
Over the years (since 1960), more and more data has been added with each new name receiving the next available ID number. Some names are unique, others have been entered multiple times.
Once the table is sorted by year then by time, I would like to identify the first entry for each ID and allocate it a number (column E) to show the order in which people first did the challenge regardless of how many times they have actually done it.
By doing this, I would be able to tell who was the 50th person or the 100th person to do so and ultimately, how many unique names have completed the challenge.
I am unsure of how to even start looking at this but I do have a separate list of ID numbers (in column M but not in the table).
Starting at the first entry in this list, VBA would search down column A until if found the first match then add "1" to a new column (E).
The second number would be searched for and "2" placed in column 'E' and so on until the end of the list of unique IDs.
All help appreciated!
Over the years (since 1960), more and more data has been added with each new name receiving the next available ID number. Some names are unique, others have been entered multiple times.
Once the table is sorted by year then by time, I would like to identify the first entry for each ID and allocate it a number (column E) to show the order in which people first did the challenge regardless of how many times they have actually done it.
By doing this, I would be able to tell who was the 50th person or the 100th person to do so and ultimately, how many unique names have completed the challenge.
I am unsure of how to even start looking at this but I do have a separate list of ID numbers (in column M but not in the table).
Starting at the first entry in this list, VBA would search down column A until if found the first match then add "1" to a new column (E).
The second number would be searched for and "2" placed in column 'E' and so on until the end of the list of unique IDs.
All help appreciated!