Remove Duplicates in Excel column? (XP)

Topic

New Reply

Hi,

I am trying to get help with a problem.
Pls. refer to the Excel file attached.

I need to be able to remove all duplicate entries in the column automatically. How can I do that?

It should go through the whole column, irrespective of the no. of entries & remove all duplicates. It should handle alphanumeric strings, e.g. email addresses.

Please help!!!! TIA.

Reply | Quote

Replies

Use data, filter,advanced filter. Set it to copy to another location and check the unique records box.

Reply | Quote

Did the biz. Thanks.

Reply | Quote

Did the biz. Thanks.

Reply | Quote

Use data, filter,advanced filter. Set it to copy to another location and check the unique records box.

Reply | Quote