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