Excel Magic Trick 412: Data Validation Drop Down List & OFFSET Function

By: Screen Rant

49 views

Uploaded on October 14, 2009 by ExcelIsFun Powered by YouTube

See how to use Data Validation Drop Down List, Relative Cell References and the OFFSET function to add five Validations with just one formula. Then see how to copy Data Validation with the Fill Handle.

Tags:
Excel, Data, Validation, Drop, Down, List, Relative, Cell, References, Offset, Function, Excelisfun, Mike, Gel, Girvin, Highline, Community, Colleges, Science & Tech

ALSO FROM THIS CHANNEL

Comments on Excel Magic Trick 412: Data Validation Drop Down List & OFFSET Function

RECOMMENDED CHANNELS