Yes, firstly number column D as a helper column, put a 1 in D1 and
CTRL-Drag to following rows, this should sequential increase for each
row.

assuming data is in A1 to A999

In B1 enter
=SMALL(A$1:A$999,D1) with crtl/shift/enter to enter the array
formula
and formula drag this to the last line of data

in C1 enter
=" "&B2&" = "&COUNTIF(A$1:A$999,B1),"")
in C2 enter
=IF(B2<B1," "&B2&" = "&COUNTIF(A$1:A$999,B2),"")
and formula drag this to last line of data

This produces the required counts, you can omit the " "&B2&" = "& if
you just want numbers


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390071