Loading...

Excel 2010 Magic Trick 817: Extract Unique List of Values For Dynamic Data Validation Drop Down List

38,826 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 Oct 9, 2011

Download file: https://people.highline.edu/mgirvin/E...
1. See how to use a helper column to Extract Unique List of Values For Dynamic Data Validation Drop Down List.
2. See the functions, COUNTIF, IF, SUM, INDEX, MATCH, ROWS.
3. Non-array formula method
Related video: Excel 2010 Magic Trick 818: Extract Records For Each Country To A New Sheet With Formula

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...