Try this:

Assumes there is at least 1 number that appears more than once.

Assume the numbers are in a named range called rng. rng = A2:A20

Enter this formula in D2:

=MODE(rng)

Enter this array formula** in D3 and copy down until you get blanks:

=IF(ROWS($1:2)<=COUNT(1/FREQUENCY(rng,rng)),MODE(IF(COUNTIF(D$2:D2,rng)=0, rng+{0,0})),"")

Enter this formula in E2 and copy down as needed:

=IF(D2="","",COUNTIF(rng,D2))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"tht" wrote in message
...
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?