Hi all,

Not sure if I am approaching this the right way and would appreciate any guidance.

I have two columns: State and Company. There are only 50 states, but about 4000 unique companies. There are about 15,000 entries in the list overall because of various repeats. Each entry consists of the company and the associated state.

I am trying to find which company has the most entries within each state. So, if I put "Alabama" in as the state in the toggle area, I would like the company with the most counts in the Company column to be returned, but only among those companies that have entries in "Alabama." I have tried to do this with combinations of INDEX(MODE(MATCH etc. but I'm having trouble only returning the match for a specific criteria.