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

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

Maybe..........

Tools Data Analysis Histogram...........

Or,

Data Filter AutoFilter will let you look at them.......


Vaya con Dios,
Chuck, CABGx3


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