Loading...

Excel Magic Trick 916: Remove Blanks In Data Validation Drop Down List 5 Examples

87,323 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 May 10, 2012

Download workbook: http://people.highline.edu/mgirvin/Ex...
3 examples of how to Remove Blanks In Data Validation Drop Down List 5 Examples:
1. Learn that "Ignore Blanks" Check Box does not remove blanks from list, but instead it avoids an error message when cell is empty
2. Remove Blanks from data set using: GoTo (F5), Special Button, Blanks, OK button, Right-Click and Delete Cells, Shift Up
3. Array Formula To Extract Data for Non-Empty Cells using the functions IF, ROWS, COUNTA, INDEX, SMALL, ROW and Comparative Operator NOT
4. Array Formula To Extract Data for Non-Empty Cells using the functions IF, ROWS, COUNTA, INDEX, AGGREGATE, ROW and Comparative Operator NOT
5. Create Dynamic Range Defined Name using INDEX and COUNTIF and the "One Or More Character" Criteria "?*"

  • Category

  • License

    • Standard YouTube License

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