You Tubers Love Excel #1: Dynamic Data Validation & OFFSET

Tags:
2003 2007 Colleges Community Data Dropdown Excel Function Gel Girvin Highline List Mike Offset Validation Vlookup
ExcelIsFun
  • Affiliate Submitter:
    ExcelIsFun
  • International International
  • Comments: 0
  • Views: 275
  • Added: 01-Apr-08

In this series of videos, You Tubers Ask ExcelIsFun Questions. See how to create a dynamic Data Validation Dropdown list that will update when you add new records. See how to use Data Validation, the VLOOKUP function and a named formula that uses the OFFSET function.

Have you ever had a Data Validation dropdown that you would like to have automatically and dynamically update? This is the video for you!

  1. Categories: Science & Tech
Comments on

You Tubers Love Excel #1: Dynamic Data Validation & OFFSET

6 Comments | Add Comment
  • Dear tttukr, ...

    Dear tttukr,

    EXCELlent!!!! I am glad they can help!

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1213530422 Reply Spam Moderate Up Moderate Down
  • Educational and ...

    Educational and entertaining!!! WOW!!

    By tttukr [Affiliate User] 1213527598 Reply Spam Moderate Up Moderate Down
  • Dear snowflake410, ...

    Dear snowflake410,

    What kind of graphs/charts do you need help with? What specific problems or questions do you have?

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1210172060 Reply Spam Moderate Up Moderate Down
  • I need help on ...

    I need help on making graphs on Excel:(

    By snowflake410 [Affiliate User] 1210169494 Reply Spam Moderate Up Moderate Down
  • Dear eepsm0m, ...

    Dear eepsm0m,

    Yes, I agree that more teachers should use videos online. Then students would always have a rewind button on their teacher.

    The big problem in the United States is that we teachers do not get paid well at all. It takes a long time to learn all the new technologies that come out. The only reason I do it is because I have so much fun with Excel that doing all this stuff is like having a vacation!!!

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1209365244 Reply Spam Moderate Up Moderate Down
  • This is very ...

    This is very helpful. Wish more teachers would use this idea.

    By eepsm0m [Affiliate User] 1209328718 Reply Spam Moderate Up Moderate Down
6 Comments | Add Comment
 
kpins