Hello,

I'm looking for a formula to show me the top 5 (or other top) most frequent text in a FILTERED list and next to it, to show the presence in % of this text in FILTERED list.
I'm currently using this formula but it only gives the most frequent.

=INDEX(Table4[SIRE NAME],MODE(IF(SUBTOTAL(3,OFFSET(H2,ROW(Table4[SIRE NAME])-ROW(H2),0)),MATCH(Table4[SIRE NAME],Table4[SIRE NAME],0)*{1,1})))

Thank you.