cnrlzen
asked on
Microsoft Excel Formula help
I am trying determine the most popular fruit based the number of times an answers is displayed. If you look at the data below the answer would be "apple" because three people selected apple.
Customer Choice
John Apple
Susan Orange
Jane Apple
Linda Cherry
Tom Grapes
Bob Cherry
Jill Apple
Customer Choice
John Apple
Susan Orange
Jane Apple
Linda Cherry
Tom Grapes
Bob Cherry
Jill Apple
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the points, cnrizen..
EE1.xlsx