There was also a similar thread under Excel Worksheet functions titled
"Delete duplicates".

Solution provided was to use:
DataFilterAdvanced filterCopy to another location and unique records
only.

Once u get ur unique numbers in a separate table u can then use
COUNTIF(range,criteria) to count the occurence of each unique number in
the original list.

Cheers.


--
terabar
------------------------------------------------------------------------
terabar's Profile: http://www.excelforum.com/member.php...o&userid=24272
View this thread: http://www.excelforum.com/showthread...hreadid=379248