713.589.2655
Houston, Texas

210.568.3904
San Antonio, Texas


Course Links

training schedule
 
  •  Houston
 
  •  San Antonio
training schedule
training schedule

Resources

training schedule
training schedule
training schedule


>
  
training schedule Course
 Schedules

Houston Schedule
>
 
 
San Antonio Schedule
>
  
 

>
>
>
 
 

Better Business Bureau

 

 

.


 

 

Microsoft Excel TrainingMicrosoft Excel: Hiding Duplicate Rows


Overview

  • Hiding Duplicate Records. Do you have duplicate rows in your dataset? Learn how to hide the duplicate rows with just a few clicks.

By using the Advanced Filter feature in Excel, we can hide the duplicate rows without actually deleting them.


How To Hide Duplicate Records

Download Sample File: HideDuplicates.xls

1. Open your Excel Worksheet with your data or use our sample file.

2. Highlight your entire dataset.

3. Select Advanced Filter from your menu.

  • 2007 and 2010 Users:

Go to the Data Tab and select Advanced in the Sort and Filter group.

Excel Hide Duplicate Records

  • 2003 Users:

Go to the Data menu, select Filter, then Advanced Filter.

Excel Hide Duplicates 2

4. In the Advance Filter dialog box:

  • Confirm that all your data is selected in the List Range field.
  • Ensure that the Criteria Range is left blank.
  • Check the box for “Unique records only”.
  • Click OK.

Hide Duplicate Records Excel 2007

5. That's it, now only the unique records are shown. You can copy and paste the results to keep the unique set.

 

 

Excel Solutions Team is committed to helping you increase productivity by improving your knowledge of the tools you use everyday. Contact us at 713.589.2655 for pricing and registration information.

• Hands-On, Instructor-Led Training Courses
• Individual & Group Corporate Classes
• Fully Customizable Training Sessions
• Training at Our Location or Yours
• Professional Grade Courseware
• Full Day & Half Day Options

 

 
     
 

 

 
   
     

                                                         |   Home   |   Email Us   |   Privacy Notice   |   Site Map   |