Excel Count Number of Instances and Return Highest

mjfigur
mjfigur used Ask the Experts™
on
Excel 365

I am trying to take the attached sample file and go through the 'Rating' column and count the number of instances of 'A', 'S', and 'NI'. I need it to count the number of times it sees each one and then return in cell B2 which one had the most instances.

For example in this column 'A' occurred most often so it would return 'A'
Sample.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Why do these cells contain more than one instance of the ratings?
Finance Analyst
Commented:
See attached using combination of LEN and SUBSTITUTE to determine number of occurrences in each cell.
Sample--3-.xlsx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial