top of page
Search

Microsoft Excel - Extract a Unique List of Values from a Column

How can you take a column with duplicate values and extract just the unique values?

Follow along as I demonstrate four techniques you can use to get the unique values from a column within a master list.

  • Microsoft Excel INDEX, MATCH and COUNITF functions

  • Remove Duplicates

  • PivotTable

  • UNIQUE function


Download the example file to follow along:


Want to learn more? Take a look at my Complete Microsoft Excel course:

 
 
 

Comments

© 2019 by Office Newb, LLC.

bottom of page