Excel How to Extract Unique Values in a List
How to Extract Unique Values in a List
Looking for ways to get the unique list on your items using a formula? Maybe you're thinking of adding a helper column to count the occurrence of each item and get its first instance. This is definitely one way of achieving this. But, certainly there's smoother way of getting the job done.
If you're using Office 365, you can use Unique function
If you're using other MS Office version, an array formula with combination of Index and Match functions is your solution.
Watch this short video tutorial to learn the trick.
In order to be irreplaceable one must always be different
Coco Chanel
*************************************************
Want to learn more about Excel?
SUBSCRIBE NOW:
/ @romeocostillas
YouTube Playlist:
• Excel Keyboard Shortcut Control Combi...
Or visit me on Facebook at / excelbyromeocostillas
See you there!
Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert
Microsoft Innovative Educator
Discrete Event Simulation Modeler
#excelbyromeocostillas #Excel #ExcelTips
Watch video Excel How to Extract Unique Values in a List online without registration, duration hours minute second in high quality. This video was added by user Romeo Costillas 09 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 55 once and liked it 1 people.