If your numbers are in column A, with a heading in cell A1, then enter this formula in Cell B2, and
copy down to match column A:

=IF(COUNTIF($A$1:A2,A2)=1,COUNTIF(A:A,A2)+ROW()/100000,"")

Then in C2, enter this formula, and copy down for as many rows as modes you want:

=INDEX(A:A,MATCH(LARGE(B:B,ROW()-1),B:B,FALSE))


HTH,
Bernie
MS Excel MVP


"Laffin" wrote in message
...
I have a large data set. Within the column I have determined the mode. How
do I find the second most common number, third most common, etc.?

240
240
240
240
240
240
240
240
288
288
288
300