There may be an easier, single-formula approach, but this is what I came up with:
With
R5:R10000 containin alpha-numeric entries, blanks are allowed.
This ARRAY FORMULA, completed by holding down CTRL and SHIFT when you press ENTER (instead of just pressing ENTER) begins the list of the most occurring entries
Copy that formula down as far as you need.
Note_1: That formula will stop listing when it reaches the count of unique values in $R$5:$R$10000
Note_2: Some of those addresses reference through cell R10001
Is that something you can work with?
Bookmarks