I'm trying to create a list of alphabetized text items with frequency
count in the adjacent column.

I want to be able to add new entries to the list and then have Excel
compare the new entry to the existing entries and either add the item
if it doesn't exist or update the count next to the existing entry if
already exists.

I've done a lot of searching and haven't found a way to do this,
although it seems like a pretty standard case.

Any ideas?

Thank you!