I am trying to make a spreadsheet for NFL quarterback. There are two columns that I need this formula for. They are the team and opponent columns. I want a formula that will show me the most common team in each column. The problem I have though is when there are multiple teams that appear the same amount of times in one column. I cant find a formula to show both the teams. What I have now just whos one of them even if there is a tie. I would honestly be fine with something that says "error" or whatever, but it doesn't work for me if only one team shows when there are multiple tied.
Bookmarks