I need to incrementally increase the number in column A for every unique record in column B. In other words, Cell A1 has the number 1, Cell B1 has the name John. John is in the 1st 10 rows of column B and all Johns receive the number 1 in column A. Cell B11 has the name Cindy, and this needs the number 2 in column A and so forth.
Thank you
Thank you