Extract unique values in Excel - 2 ways (With and Without Unique function)
In this Hindi Excel video, you will see how to get unique values from a list in Excel.
Here I have shown 2 formula method
1st method using Unique function (available in Office 365)
But Unique function is available in office 365, in the second method you can get unique values without using the Unique function.
2nd formula method (non-array formula) using helper column which is supported in all the Excel versions
✔✔ Jump to a section
Get unique values using Unique function 00:02
Get unique values using helper column formula to get unique values 00:58
🔰 Click the below link to download the file.
https://drive.google.com/file/d/1m2w5...
🌐 Websites 🌐
🌎https://learnyouandme.com
🎫 Make your Digital Visiting Card https://mydvc.info/
🔵Facebook / learnyouandme
🔴Quora link https://www.quora.com/profile/Abhishe...
📌📌You can watch and learn from the below videos also.📌📌
✅ How to count unique values in Excel (count unique or distinct occurrences -2 ways) • How to count unique values in Excel (...
✅ Insert page break in Excel | Auto insert page breaks on value change • Insert page break in Excel | Auto ins...
✅ Vlookup image in Excel | picture lookup technique in Excel | picture lookup Hindi | image lookup • Image lookup formula in Hindi | pictu...
✅ How to create a Dependent Drop Down list in Excel - Part 1 (Excel Dependent dropdown list ) • How to create a Dependent Drop Down l...
✅ Excel CTRL+ENTER shortcut key | Excel shortcut keys | Excel magic tricks • Excel CTRL+ENTER shortcut key | Excel...
✅ Compare two columns in Excel quickly for matching values or amt differences • Compare two columns in Excel quickly ...
#learnyouandme
#learn#you#and#me
#excel#unique#values#list
Watch video Extract unique values in Excel - 2 ways (With and Without Unique function) online without registration, duration hours minute second in high quality. This video was added by user LearnYouAndMe 04 October 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,825 once and liked it 18 people.