One way is it use a Pivot Table. Say we start with data like:

items
3
45
3
34
100
7
100
45
45
3
34
34
2
8
100
100
3
67
34
34
1
67
100
100

the pivot table would be:

Count of items
items Total
3 4
45 3
34 5
100 6
7 1
2 1
8 1
67 2
1 1
Grand Total 24


After sorting by Total we get:

Count of items
items Total
3 4
45 3
34 5
100 6
7 1
2 1
8 1
67 2
1 1
Grand Total 24

--
Gary''s Student - gsnu200725


"tht" wrote:

I have a lot of numbers in a data field. I cam find the most common. I know
how to make excel count each one. But can someont tell me how to make the
2nd and so on show up in the selected cell?