= LET(
distinct, UNIQUE(names),
count, COUNTIFS(names, distinct),
ordered, SORTBY(distinct, count),
INDEX(ordered, {1;2;3}))
=LET(u,UNIQUE(names),
c,COUNTIFS(names,u),
s,SORTBY(u,c,-1),
TAKE(s,3))
That brings it up to date. I only got the function yesterday!Hi to both!
Another way, with Microsoft 365 insider beta (similar to @Peter Bartholomew approach) :
Code:TAKE(s,3))