How to find duplicates in Excel

Takeaway: You’ll need more than one trick up your sleeve to find duplicates in Excel.

 

In the duplicate world, definition means everything. That’s because a duplicate is subjective to the context of its related data. Duplicates can occur within a single column, across multiple columns, or complete records. There’s no one feature or technique that will find duplicates in every case.To find duplicate records, use Excel’s easy-to-use Filter feature as follows:

  1. Select any cell inside the recordset.
  2. From the Data menu, choose Filter and then select Advanced Filter to open the Advanced Filter dialog box.
  3. Select Copy To Another Location in the Action section.
  4. Enter a copy range in the Copy To control.
  5. Check Unique Records Only and click OK.

 

 


About Us

Hyperfuturevision now provides a full range of IT services for small and medium businesses.

Today we offer the technology services businesses need to be successful in today’s marketplace-including network administration, network security, business continuity and web services.

Contact us

Schedule a free assessment with one of our technology professionals
(877) 425-5999 (phone)

Contact us

Newsletter Sign Up

Sign up and receive periodic emails with special offer from HyperFutureVision and Expetec Technology Services.


Copyright © 2012 Hyperfuturevision. All rights reserved. | Login