Dynamic Unique Values in Excel | Extract Auto update Unique Value List using Formulas | Excel Tricks

preview_player
Показать описание
Hi All

This short video will bring to you the easiest method through which you can generate unique value list from any table array.
As soon as you add valued to your base table, the auto-update unique value list will update automatically.
This unique value list can be further used to create data validation dropdown lists.

Stay tuned for more..

Excel Insider

Download the practice file here:

#ExcelTricks
#UniqueValues
#ExcelMagic

Dynamic Unique Values in Excel
Extract Auto update Unique Value List using Formulas
Excel Tricks
Рекомендации по теме
Комментарии
Автор

loved it... as usual put link excel file im the description

ubaidillahmuhammad
Автор

when I am giving table reference it gives error N/A only work when it is cell reference.

SantoshLaserTechnologies
Автор

It's not working when my list has a data filter and I apply the filter. What should be the solution?

SantoshLaserTechnologies
Автор

Make the point clear at 1:12, and also tell us how to freeze the cell, when I select the cell it shows extract instead of cell name.

fawadgul
visit shbcf.ru