Monty

Chip Pearson has several duplicates functions(tagging, counting etc.) on his
site. Perhaps one of them will return what you want.

http://www.cpearson.com/excel/duplicat.htm


Gord Dibben Excel MVP

On Wed, 12 Jan 2005 12:31:08 -0800, "Monty"
wrote:

i have over 1000 duplicate numbers on one worksheet what type of formula do i
need to run in order to bring back how many ie 2001,2002,2003, 2010 etc.

thanks