| 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:
I have installed 2 versions 2003 and 2007. I can switch them. |
|
#4
|
|||
|
|||
|
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 |
|
#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 | |||
Hybrid Mode
