How to copy and paste unique values in Excel
If you're wondering how to copy and paste unique values in Excel, this video shows you a quick way to do that.
If your data contains a lot of duplicates, you may want to get a copy of it with only the unique values.
All you have to do to get the unique values list of your data is to follow the steps of this tutorial:
⇨ add a proper label
⇨ select data
⇨ click Data - Advanced
⇨ select the Copy to another location
⇨ select the location
⇨ check the Unique records only box
I hope this video is useful to you and if you learn something new, please hit the like button so we can reach and help more people for free. ❤️
Timestamp:
00:00 Intro
00:12 Copy - Paste Unique
00:57 This is how you do it 🥰
🔴 RECOMMENDED VIDEOS/PLAYLISTS
🎥 Financial functions: • 💰 Compound interest calculator templa...
🎥 Common errors: • 🚨 How to solve the #DIV/0! error in E...
🎥 How to tutorials: • How to use UPPER in Excel
🎥 Regular functions explained: • BASIC EXCEL FUNCTIONS
Feeling generous? I like coffee.🤗
☕ https://www.buymeacoffee.com/cogwheel