|
Featured Tutorial
Featured Macro
Excel Magic Trick 698: Extract Unique Items For Data Validation Drop-Down List
See how to create an Expanding Data Validation Drop-down List from Table With Duplicates with these tricks:
1. INDEX function to create Dynamic Ranges using Defined Name Formula
2. Unique Count Formulas using SUMPRODUCT and COUNTIF functions
3. Unique List Data Extract Formula using FREQUENCY function and IF, SUM, ROW, ROWS MATCH functions.
4. Data Validation Drop-down List using INDEX function to create Dynamic Ranges using Defined Name Formula
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
1. INDEX function to create Dynamic Ranges using Defined Name Formula
2. Unique Count Formulas using SUMPRODUCT and COUNTIF functions
3. Unique List Data Extract Formula using FREQUENCY function and IF, SUM, ROW, ROWS MATCH functions.
4. Data Validation Drop-down List using INDEX function to create Dynamic Ranges using Defined Name Formula
Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm