Loading...

Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down List

30,844 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Sep 3, 2010

Download file: http://people.highline.edu/mgirvin/ex...
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/Ex...

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...