How to determine Nth occurence in a column?
Do you know of any function or combination of functions that can achieve a new column in the data as the "occurrence" column in the screenshot below?
I would like to know if the ID in the first column is the 1st, 2nd ... Nth occurrence in that column. Is there a way to achieve this?
Thanks in advance.