Hello,
I am trying to find the most occurring text in my range.
This formula works well to find the most occurring text
=ARRAYFORMULA(INDEX(A1:A17,MATCH(MAX(COUNTIF(A1:A17,A1:A17)),COUNTIF(A1:A17,A1:A17),0)))
Now, I want to tweak the formula to find the second highest, third higest etc.
Please let me know.
This is not an Excel formula - are you using Google Sheets?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Yes, Google Sheets, that is right, can you please let me know to tweak it please? Shouldnt, make a difference right?
Apologies should have clarified.
Last edited by AliGW; 06-06-2021 at 09:49 AM. Reason: PLEASE don't quote unnecessarily!
Yes, it does make a difference. I am moving this to the correct forum sub-section.
You can use LARGE:
=ARRAYFORMULA(INDEX(A1:A17,MATCH(LARGE(COUNTIF(A1:A17,A1:A17),2),COUNTIF(A1:A17,A1:A17),0)))
adjust the 2 to whatever value you want.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks