How to Extract Unique Values in Excel

✅ Download the free course files to follow along

In this Excel video tutorial, we will talk you through how to extract unique values from lists.

We start by looking at what unique values are, and we move on to looking at how we can extract the unique values from a list. Finally, we move on to showing you the different ways to extract the unique values from a table and plain text, including using the UNIQUE function.

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[superstar]

you just helped me in 30 seconds figure out something I've been trying to do for a month
THANK YOU

[qiqrghc]

fyi - if you had copied them and then clicked on a blank cell and did the paste special, transpose, it would have worked.

[RonDavidowicz]

It seems like if you have older versions of Excel, you can just copy the entire column you want and then use remove duplicates.