U dont' need a macro for this ! just follow my steps.

Step1: Sor the names in any order (Data-- Sort)

Step2: at the most-right-hand column, input the following formula

=IF(A2=A3, "duplicated", "ok") , so ur names should be at column A.

Step3: Drag the formula till the end of the column, and u'll see. If there
are duplicated names, the column with our formulas will show "duplicated" so
those names do not duplicate will show "OK" .

Step4: Filter it (Data -- Filter-- Auto Filter). Go to ur right-most
column, filter out duplicated and high light them

Step5: Take out the filter. DONE !!!!!


Now u have duplicated names highlighted, or vice versa ^_^!.

Allen P. W.

Deutsche Bank AG, Bankok.






"Brenda" wrote:

Can anyone help me with writing a macro to find duplicate names in
spreadsheets with 6,000+ entries?