Glad it worked - thanks for the reply!

Mike Mike wrote:

Thank you!!


"Lori" wrote in message
ups.com...
There are various methods to do this - here's one:

1. Make a copy of Column A in column B then select C1.
2. Choose Data Consolidate; Function: Count; Range: A:B; Labels: Left
Column
3. Choose Data Filter Auto Filter and filter everything greater
than 1.

You could then copy this selection to another location if you wanted.