Column B is a list of number - representing Contact ID's. Some appear once, twice, three time or manybe even 4
In Column A, I want a 1 if it is the 1st time the number appears, a 2 if it is the 2nd time the number appears... and so on.
Is there a formula that will do this? Thank you!