I have a column that contains numerous repeating text values. I wanted to know if there is a way to create a list within the same worksheet that can automatically be populated with each unique value, then total them in an ajacent cell. example
data:
thomas
thomas
john
james
thomas
james
jane
john
intent:
thomas 3
john 2
james 2
jane 1
Bookmarks