Remove duplicate items in the table

[Peter Last]

Hello,

I am a beginner in Excel. I have a big table with my customers. It i
imported from SAP. In the table are a lot of repeating rows, that I wan
to delete. Is there some quick way how to do this?

Thanks.


Pete

 

[Spencer101]

Hello,

I am a beginner in Excel. I have a big table with my customers. It i
imported from SAP. In the table are a lot of repeating rows, that I wan
to delete. Is there some quick way how to do this?

Thanks.


Peter

Hi Peter.

What version of Excel are you using

 

[AlPano]

Hello,

I am a beginner in Excel. I have a big table with my customers. It i
imported from SAP. In the table are a lot of repeating rows, that I wan
to delete. Is there some quick way how to do this?

Thanks.

Peter

Hi Peter,

you can try Advanced Filter. It is on the menu Data-> Filter -
Advanced. Then select your table and check Unique records only. There i
an example http://excel-example.com/duplicates/delete-duplicate-rows

A