Delete duplicate records in the table
 

Hi,

I'm assigned a task to clean the data of one excel file which delete the
duplicate records. For example:

cust# custname add1 add2....

delete record when cust# is duplicated.

Since this is a huge table, I like to run some code to do so.

Can someone give me some code examples?

Thanks,
Sarah

Delete duplicate records in the table
 

Hi
see: http://www.cpearson.com/excel/deleti...eDuplicateRows

--
Regards
Frank Kabel
Frankfurt, Germany


Sarah G. wrote:
Hi,

I'm assigned a task to clean the data of one excel file which delete
the duplicate records. For example:

cust# custname add1 add2....

delete record when cust# is duplicated.

Since this is a huge table, I like to run some code to do so.

Can someone give me some code examples?

Thanks,
Sarah

Delete duplicate records in the table
 

Thank you for your reply, it helps.
Sarah
"Frank Kabel" wrote in message
...
Hi
see: http://www.cpearson.com/excel/deleti...eDuplicateRows

--
Regards
Frank Kabel
Frankfurt, Germany


Sarah G. wrote:
Hi,

I'm assigned a task to clean the data of one excel file which delete
the duplicate records. For example:

cust# custname add1 add2....

delete record when cust# is duplicated.

Since this is a huge table, I like to run some code to do so.

Can someone give me some code examples?

Thanks,
Sarah