Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove duplicate items in the table
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 |
#2
|
|||
|
|||
Quote:
What version of Excel are you using? |
#3
|
|||
|
|||
Quote:
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 |
#4
|
|||
|
|||
Hi Spencer,
I have installed 2 versions 2003 and 2007. I can switch them. |
#5
|
|||
|
|||
Quote:
thank you for the advice. It seems that it works well. Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove grouped items and fields from pivot table | Excel Discussion (Misc queries) | |||
How can I remove old items in a drilldown box in a pivot table? | Excel Discussion (Misc queries) | |||
Remove Duplicate Array Items | Excel Programming | |||
How do I remove items listed in a pivot table drop down list box | Excel Discussion (Misc queries) | |||
Duplicate Items | Excel Programming |