98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training class - Duplicates rows table
microsoft excel training class - Duplicates rows table
Resolved · Low Priority · Version Standard
Steve has attended:
Excel Advanced course
Duplicates rows table
What is the best way of automatically deleting duplicate rows in an Excel table to generate a non duplicated table?
RE: duplicates rows table
Well there are several ways you could tackle this.
First, make a copy of your file, so that if you make a mistake, you can go back to the original.
Here are the steps:
1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.
Copy and paste filtered list to desired location.
DONE
That is one simple way of doing it.
Richard
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Switch on smart tags – Excel 2007In order to use smart tags, make sure they are turned on, to do this: |