Look at the FREQUENCY function. You have to specify the data array and bins
array.

Dave
--
Brevity is the soul of wit.


"linzi00" wrote:

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