Microsoft Excel - Extract a Unique List of Values from a Column
OfficeNewb.com OfficeNewb.com
20.8K subscribers
71,514 views
394

 Published On May 6, 2022

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:
https://www.officenewb.com/post/micro...

Want to learn more? Take a look at my Complete Microsoft Excel course:
https://www.udemy.com/course/microsof...

show more

Share/Embed