If you're wondering how to enter the same data in multiple cells at once in Excel, this video shows you a quick way to do that.
If your want to have your data sorted after the first digit of each number, you may want to .
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