Forum Discussion
Solved
Find the Mode of Row Values Based on ID Column (Favorite Fruits)
Hello all, I am trying to find a way to determine everyone's favorite fruit. This is the table that I have: ID Name Fruit Eaten 1 Joe Banana 1 Joe Banana 1 Joe Ora...
Riny's suggestion is the easiest, but if you prefer a formula, see the attached.
Perfect, thank you! This is actually what I will use because there are too many "fruits" in the actual table I am using this on for a pivot table.
