Quote:
Originally Posted by Peter Last
Hello,
I am a beginner in Excel. I have a big table with my customers. It is imported from SAP. In the table are a lot of repeating rows, that I want 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 is an example
http://excel-example.com/duplicates/...duplicate-rows
Al