Hi all
I am hoping this is a fairly simple task for someone. It may not even require VBA. I have a table with a list of dates and venues. I am looking to create an ID for each of these. So for example, on 11/11/17 for venue A, these should all be assigned an ID of "1". Then for 12/11/17 for venue A, these should have an ID of "2" and so on.
I have attached a sample workbook and have highlighted in Col C what I am looking to achieve.
I hope there is someone that can help me with this problem please.
Bookmarks