How to count duplicates...

[WGUSTUDENT]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel am a new excel user and am struggling ...

have several lists of size 25, 50, 75, 100, 500, 1000. the cells in each list has a randomly generated number between 1 and 365

for each list i need to count the number of duplicates

and while i have been able to conditionally format the cells to highlight the duplicates, i cant seem to count the correct number

any help would be appreciated

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
am a new excel user and am struggling ...

have several lists of size 25, 50, 75, 100, 500, 1000. the cells in each list
has a randomly generated number between 1 and 365

for each list i need to count the number of duplicates

and while i have been able to conditionally format the cells to highlight the
duplicates, i cant seem to count the correct number

any help would be appreciated

I am not sure what you want. Do you simply want to count the number of items
that have duplicate entries, count the number or each occurrence of each
item, or count the number of unique entries? If you could give an example of
your data, and the expected results, that will help us to provide an answer.