Hello,

For starters, I am using Excel 07.

I have a list of phone numbers which are all in one column. I am trying to
count the number of times each phone number appears on this list. I would
usually just sort and manually count, however, the current list is over 3,500
rows long so that is not an option. Could someone please advise me of how to
accomplish this?

Also, I am aware that this can be done with pivot tables but I need to be
able to modify the list once I have the number of occurrences.

TIA