Thread: Ranking
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
linzi00 linzi00 is offline
external usenet poster
 
Posts: 1
Default Ranking

How do I obtain a ranking in excel from a lits of numbers based on the
frequency with which the numbers show up?
ie) list of numbers: 6,5,2,2,8,4,2,0,3,3,7,3,8,3,8,3
Rank: 1. #3
2. #2 &#8
3. #0,4,5,6,7