formula

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" <[email protected]>
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" <[email protected]> wrote in message
news:[email protected]...
> 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