Drop Down List of Distinct Values in Excel
4-Step process to create a drop-down list of distinct (unique) values.
Ask Your Excel Question #9
1. Create a table of input list and name the list of values
2. Formula to create a distinct list
3. Calculate the number of distinct values
4. Implement data validation/drop-down list with OFFSET function
Reference Videos & Pages (that I learned from and I would recommend for more information on this topic)
Excel is Fun - Array Formula:
• Excel Magic Trick 1023: Extract Uniqu...
Excel Is Fun - Count Unique values: • Excel Magic Trick # 272: Count Unique...
Get-Digital-Help:
https://www.get-digital-help.com/2009...
Leila Gharani:
• Extract UNIQUE Items for Dynamic Data...
My Spreadsheet Lab: https://www.myspreadsheetlab.com/vide...
About this video series:
‘Ask Your Excel Question’. In this series, I provide solutions to questions that I receive from our community.
These videos will be short and to the point, addressing a specific feature or concept or a formula. If you would like to be notified of these videos, please subscribe to our YouTube channel.
If you would like to ask your own questions, please post them in the comments below. I will do my best to answer.
Social:
Subscribe to YouTube: http://www.youtube.com/user/theindzar...
Facebook: / theindzara
~-~~-~~~-~~-~
Please watch my latest video: "Highlight events, weekends and holidays on calendar in Excel" • Highlight events, weekends and holida...
~-~~-~~~-~~-~
