98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Duplicates
Duplicates
Resolved · Low Priority · Version 2003
Thu 24 Sep 2009, 16:16Delegate Charlie said...
Charlie has attended:
Excel Intermediate course
Duplicates
How do I search for duplicate entries in a column?
Mon 28 Sep 2009, 11:04Trainer Andrew said...
RE: Duplicates
Hi Charlie
We can achieve this by using Excel's advanced filter feature.
Click in your data to be filtered. Make sure each column of data has a data label at the top of it. From the Data menu choose Filter > Advanced filter
Excel will highlight the data table - make sure it has selected the data correctly. From the dialogue box that appears select to Filter the list in place then add a check mark to the Unique records only box.
Click on OK and Excel hides rows containing duplicate values.
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew
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:Sorting List SubtotalsIf you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. |
