Assigning instance number

[jph89]

I have 129,799 rows of data and A-O columns. The data is essentially a call log and in Column 'K' I have a phone number. I have sorted all of my data by Column 'A', time of call, from oldest to newest.

I have created a column to the right of my data, column P, which I would like to assign a phone number instance. I have tried doing: =countif($K$2:K2,K2) and dragging it down but it takes hours to calculate.

Ideally, VBA would be able to accomplish the following in column P


Column K Colulmn P
888-888-8888 1
888-885-8888 1
888-888-8888 2
888-880-0000 1
888-880-0000 2


Thanks for any help.

[shg]

This takes less than a second on 100,000 cells:

Please Login or Register  to view this content.

[jph89]

Oh my. You are are my savior.

Thank you 1,000,000 times.

[shg]

You're welcome.