=COUNTIF(A:A,A2)1

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Zeke009" wrote in message
...
I'll do my best on explaining this, it might be a little complicated...

I have a spreadsheet of 21,000 entries for machine names with a certain
application installed and all reported versions of this application. I've
used the following formula to show me duplicate occurances of machine
names
where the system has multiple versions loaded. COUNTIF($A$2:$A2,A2)1

Now that formula works fine for showing me the 2nd, 3rd or more occurance
of
a machine name. But now I need to provide a list with all machine names
that
appear on the list more than once. I am not sure how I can get the
COUNTIF
statement to identify all occurances, especially the 1st occurance of a
machine name. I really don't want to scroll through the list to delete
non-duplicate entries and this will be a weekly task for the next few
weeks.

If I was not clear in my question, please let me now and I'll do my best
to
explain it more thoroughly.

Thanks,

Zeke