You have a few options....
I like this one.

This method ignores the first occurrence of a value and displays the
duplicates.

With your list is in A10:A100, with A10 as the Heading: MyCol_A
C1: DupeTest (or blank or any text that is NOT a data column heading)
C2: =COUNTIF(A$10:A11,A11)1

(Note the dollar sign and that the formula only goes from the heading to
next cell down)

D1: MyCol_A (the same col heading as A1)
But, only if you want the list coped to another location. Otherwise, skip
that step.

<Data<Filter<Advanced Filter
List Range: (select $A$10:$A$100)
Criteria Range: $C$1:$C$2

Click the [OK] button to filter the list in place.
OR
To copy the duplicates to another area:
Check: Copy to another location
Copy to: D1 (which contains the col heading NumVal)
Check: Unique Records
Click the [OK] button

Any displayed values are the duplicates.

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Gary" wrote:

Hi,

I have a list of names in a column, i want to check if there are any names
repeated. What would be the best way to do it?

Thanks
Gary