Excel - Ranking Q

Asked By Alan Bong on 30-May-12 12:38 PM
Hi,

For example : My co (ie. restaurant) is doing a customers survey
regarding preference choice of dishes provided by us. We need to know
customers' preference choice of dishes in ranking. Ranking from 1 (the
most they like) to 3 (least)

Example 1 :
Each of the customer can only choose three dishes they like the most
in this restaurant.
Ranking from 1 (the most they like) to 3 (least)


Pls advise how to do the ranking      based on this info :-

Dish:Seafood   Dish:Beancurd	 Dish:Dessert   Dish:Special Drinks
Dish:veg
Customer 1	3		                2		1
Customer 2	1	           3		2
Customer 3		           1	                2		3
Customer 4	1	           2		3
Customer 5		           3		2	                1



Outcome : 	Ranking
Dish : Seafood	?
Dish : Beancurd	?
Dish : Dessert	?
Dish : Special Drinks	?
Dish : Veg	?

Thanks

Alan


papbab replied to Alan Bong on 30-May-12 09:58 PM
pivot table