Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training class - Duplicates rows table
|
|
|
Bookmark this page|
The UK's most regular 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. |
microsoft excel training class - Duplicates rows table
Resolved · Low Priority · Version Standard
Reply
Duplicates rows table
What is the best way of automatically deleting duplicate rows in an Excel table to generate a non duplicated table?For upcoming training course dates see: Pricing & availability
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
|
 |
|
» Forum post: Comparing Models |
Is there a tool that will allow you to compare 2 financial models to check what the differences are between them and what changes have been made?
