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
Смотрите видео Excel How to Extract Unique Values in a List онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Romeo Costillas 09 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 55 раз и оно понравилось 1 людям.