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...
Because Excel 365 is intrinsically array based, the formula
= SORTBY(Fruit, COUNTIFS(Fruit, Fruit), -1)
works without helper ranges or manual sorting.
PeterBartholomew1 , that's 2019
- And another possibility - thank you!
