Excel Forum



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





Got a Question? Ask it Here in the Forum.