I have an excel document where in one column there are 7 different categories that could be in it.
The categories are "RTW, ACC, HBG, HOM, JWL, SLG, SHO" I am trying to code in a command button a way determine which category is used the most in the column. The excel docs sometimes have hundreds of rows.
Oldie but a goodie.
=index(your_range, mode(match(your_range, your_range, 0)))
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Hello and welcome to the forum.
Here's a formula that returns the most common text in A1:A1000.
=INDEX(A1:A1000,MODE(MATCH(A1:A1000,A1:A1000,0)))
Adjust the ranges to suit your data.
Hi thank you for the help. I keep getting the error "Compile error: Expected: list separator or )" the error highlighting the colon for the range I entered "H2:H100000000)
Hi thank you for the help. I keep getting the error "Compile error: Expected: list separator or )" the error highlighting the colon for the range I entered "H2:H100000000
There is no such cell as H100000000. Limit it to the size of your data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks