Forum Discussion
Sorting a list based on number of times a word appears in a list
Hi, I have a list containing specific words (all repeated at various times). I know how to sort alphabetically, but I then need them sorted and grouped by the number of times each word appears i...
I'd use a helper column. The formula in B1 is =COUNTIF($A$1:$A$10,A1) and this has been filled down.
Sort on column B, largest to smallest:
