You could try using the FREQUENCY function, then sorting the result. Of course, multi-cell arrays don't sort, so you'll have to do a paste values first.
I know of no formula that does this directly. If you need such a formula, you could post this question in the VBA section
Bookmarks