Learn MS Excel -Video 436- Awesome Case Study – OFFSET IF DATAVALIDATION MATCH



Offset is not a normal formula. It can be used as an array also and we can set up drop downs using it like indirect function. Must watch video for hardcore excel lovers.

-~-~~-~~~-~~-~-
Please watch: “Learn Excel – Video 594 – VBA – WEB SCRAPING – CLICK ON SEARCH BUTTON”

-~-~~-~~~-~~-~-

2 thoughts on “Learn MS Excel -Video 436- Awesome Case Study – OFFSET IF DATAVALIDATION MATCH

  1. sir i have a question i want to find out working days betweem two dates without using networkdays function . excluding saturday and sunday days will be counted excluding sat and sunday

  2. Hi Ajay,
    Thanks for sharing wonderful and knowledgeable video. I need to prepare one sheet similar to your data but facing some problems.

    can you please share an email address so that I can send you the spreadsheet.

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *