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