Get access to the complete Excel Dashboards course here 👉 www.xelplus.com/course/excel-dashboards/

Leila, I just discovered your channel, and these videos are rapidly changing the way I work! They are incredibly useful, and your demonstrations are easy to follow. Thank you!

Leila, you are really so amazing! Thanks so much for putting this video together. All of your videos are so practical and you are my life saver :)

This is amazing, just added this technique to a massive vibration data spreadsheet which previously took one months worth of data (about 8 columns and 5000+ rows) where the graphs had set ranges for the month, and allowed it to pick and chose between the start date and end of the data set and update all of the graphs accordingly, so I can show 1 week, 2 weeks, 4 days...without manipulating the graphs every single time to reference new rows where that data ends. Love it.

Thank you for this video. It explained perfectly what I was trying to wrap my head around.

I was struggling with a similar chart using OFFSET() as the named range rather than INDEX(), but couldn't figure out the 'sheet name' requirement in the chart series name. You saved my day !! Thank you!!

Absolute mint ! You really explain things sooooo simply. Thanks a lot for your time and effort

Thank you SO much! This is exactly what I've been looking for, to a T -- how to chart [profits/losses/etc.] by dates using drop-down lists and a dynamic chart. This is great!

@LeilaGharani

6 жыл бұрын

That's perfect! I'm glad you found what you were looking for. Thank you for your comment.

This is exactly what I need and it is so well explained! Thank you.

Thanks for the INDEX:INDEX fun : )

@LeilaGharani

7 жыл бұрын

You're welcome Mike.

@jeylanm3133

3 жыл бұрын

Hi 🧡also we can use Offset: Offset😉

Pure GOLD! Thanks for the video, super use full!!!

Hi Leila! I spent 2 whole days trying to figure this out and your video helped me so much! THANK YOU SO MUCH!!

Mind blowing. Thats, what I was searching. Thanks

This is just great. You make it so simple. Thank you very much!!

Thank you for this, many things here I had not tried before. I copied your method, and then changed to the table like you did. I then used ‘Structured Table names’ to create the references in Name Manager, which I think makes things a little easier to read. (Making the dynamic array now ‘Spills’, so it looks a bit different to the video, but works exactly as you show it)

WAW - I Like it so much. that's the first time I learn several new out of the box tool in Excel. thank you.

WOW! that makes it so much easier - thanks for making it easy to understand, and I appreciate you explaining why you were doing what your were as you worked it out.

@LeilaGharani

3 жыл бұрын

Glad it was helpful, Rick!

Thanks Leila. This video was very helpful and provided me with just what I needed.

Excellent, loved the simplified way to teaching. Thanks a lot Leila.

@LeilaGharani

4 жыл бұрын

You're very welcome!

This is great.Just seen the power of the INDEX():INDEX() formula which I hardly knew of

SIMPLY PERFECTION !! As always, Thank You !!

the things you teach and the way you present, amazing.

@LeilaGharani

7 жыл бұрын

Thank you Craig!

Thank you Leila for an easy explanation of dynamic ranges using INDEX. Very helpful.

@LeilaGharani

7 жыл бұрын

You're very welcome.

Thank you Madam, The content was well explained and easy to understand

You indeed have saved me several hours of work every week or so. Remain blessed :)

@LeilaGharani

3 жыл бұрын

Great to hear!

Great video, did exactly what I needed. Thank you

I love this tutorials from you, very common and it change my work with data. Great work

@LeilaGharani

7 ай бұрын

Great to hear!

Very well explained with hands on example on the fly.

Thank you so much Leila!! You’re a lifesaver!! ❤️❤️

@LeilaGharani

6 жыл бұрын

You're very welcome Melanie! Glad this helps :)

Utterly brilliant. Great presentation. You have answered so many questions I have on using Excel.

@LeilaGharani

3 жыл бұрын

Great to hear!

This is amazing! Thank you so much for the tutorial

Tried it and it works really well! Thanks.

Thanks for the instructions. I made this a truly dynamic chart by avoiding the user selected start-end dates. My dates are in column C. Special Note: Both of the Start-End Dates MUST be in the column data set or the function: Index(Match):Index(Match), will display "#N/A" End date: H3=LOOKUP(9.99E+307,C:C) Returns the next largest value if the 9.99E+307 is NOT found. Start-End Date delta: J2=30 (or any other integer value) Start Date: H2=LOOKUP((H3-J2),C:C)

Amazing, just what I needed! thank you

found this to be very usefull, have been searching since 2weeks for this result.thanks leila

@LeilaGharani

6 жыл бұрын

That's great! I'm happy you found it! Sorry it took 2 weeks though....

Thank you Leila. This was so useful!!!

Fantastic, thanks for this helpful tip!

Old as this may be, your video is glorious. Thank you!!!!!!!!!!!!!!!!!!!! I subscribed

@LeilaGharani

3 жыл бұрын

Thanks for the sub, Adrian!

Hi Leila, Thank you so much for creating thid youtube channel and sharing your excel knowledge with all of us. This tutorial especially was soooo helpful ! Thanks again and keep posting videos :-) Cheers

@LeilaGharani

7 жыл бұрын

Very glad to hear that! You're very welcome :)

Thank you so much, that really helps!

Great video and simple to understand.

wonderful . thank you so so much. I've been wanting to do this for a long time!! thanks again.

@LeilaGharani

6 жыл бұрын

Very happy to hear you find this useful! Thank you for your comment.

Great Video! Thanks so much. You better' believe I liked and subscribed.

It works!! Thank you so much!!

Thank you for posting this. This is an excellent approach.

@LeilaGharani

4 жыл бұрын

My pleasure Scott. Glad you like it.

This is exactly what i have been looking for & the way explain it WoW.........................!

Very very smart way! Thanks a lot!

Very good video. I wish you the best. Quite carefully prepared.

you are great Leila !thank you so much you saved my day

Thank you very much for this tutorial its a big help

This saves my day...thank you.

Thank you, very much. That's the kind of solution I was looking for.

@LeilaGharani

4 жыл бұрын

My pleasure Fernando. I'm glad to hear that.

Thank you very much. This is amazing video!

@LeilaGharani

5 ай бұрын

Glad you liked it!

Excellent video.

Thanks. that was complicated but a big help. Forget just one "$" sign and it gets stuck. I like the unique feature that you can select the "From"-"To" dates.

Very helpful, many thanks

Thanks for the video, U R MRS EXCEL

Thanks Leila it was working amazing.

@LeilaGharani

6 жыл бұрын

Glad to hear that!

Awesome tips!! Thanks a lot.

Thanks Leila, that will help me in my daily work. Much appreciated. I have subscribed for your info :)

@LeilaGharani

4 жыл бұрын

That's great. Good to have you here.

Amazing video, i like the way you explained... Thumbs up

@LeilaGharani

3 жыл бұрын

Thank you so much 🙂

Huge help!

Thanks so much , i am searching this for ling time for my automate excel project😊

Just what I was looking for! Thanks...

@LeilaGharani

5 жыл бұрын

Glad it is helpful!

Very good presentation thumbs up!!!!!!!!!! simple and practical

@LeilaGharani

6 жыл бұрын

Thanks Jose! Glad you like it.

Exactly what I was looking for. Thank you!

@LeilaGharani

5 жыл бұрын

My pleasure. Glad it's useful.

@lukasdillinger4984

4 жыл бұрын

@@LeilaGharani And the APP is beautiful and yummy too :)

minimal & powerful.I love it.

@LeilaGharani

7 жыл бұрын

Thanks Pierre.

Clear and precise.

@LeilaGharani

5 жыл бұрын

Glad you like the video.

Thx this video helped me in creating a dynamic 12month range chart using offset..didnt know formulas can be inserted in simple chart data using name manager...

Thank you so much Leila..

Thank you SOOOOO much.

Easy to understand. Thank you very much.

@LeilaGharani

5 жыл бұрын

I'm glad you like the video.

Thank You so much Leila :)

Thank you for this Solution!

@LeilaGharani

3 жыл бұрын

You're welcome, Victor!

Great technique

thank you very much great video

very useful and thx a lot.

Thanks a lot i think u r the best Excel trainer

@LeilaGharani

7 жыл бұрын

You'r welcome. Thank you. Appreciate it!

Great video and not oversimplified.

@LeilaGharani

4 жыл бұрын

I appreciate that Joel!

Super cool..thank you

Thank you, this was very helpful

@LeilaGharani

5 жыл бұрын

My pleasure. Glad you like the video.

Outstanding ideas of Index():Index() Thank you so much, you have made my days better 😀🙏

@LeilaGharani

3 жыл бұрын

My pleasure 😊

@FahrulRizal06

3 жыл бұрын

Last month, I was so glad so that I forgot to tell you that you are my inspiration. I've tried to made my own version in Bahasa Indonesia (kzread.info/dash/bejne/aoeIrdmfhJC5YMY.html). It is a pleasure to meet your channel 😀🙏

you're so helpful

Omg this saved me! Thanks

GENIUS!!!!!!!!

i love your videos

great vid

Thank-you Leila! :)

@LeilaGharani

7 жыл бұрын

You're welcome Reuben :)

Just amazing!

@LeilaGharani

7 жыл бұрын

Thanks :)

thanks, very very much

Thank you ma'am, it really helped 🙏

@LeilaGharani

9 ай бұрын

My pleasure 😊

Excellent !!!

@LeilaGharani

5 жыл бұрын

Glad you like it!

Thanks madam for such a useful tutorial

Big like 👍🏻for this idea

@LeilaGharani

7 жыл бұрын

Thanks Abdelrahman :)

Very good thanks, nice and easy to follow and change around to fit what I need to do. Now to work out how to match the 'date' to multiple 'values' :)

@ayasobhy9183

Жыл бұрын

Have you find any solution?

life saver!

I usually do this task with offset but I had fun with INDEX:INDEX Thanks

thank you sooooooo much for index:index,

My Guru ❤

I am glad that i finally arrive at a single channel on which i can get answers for most of my excel related queries. Can you help me with formula to find out monthly high price of a stock from given dataset ( daily Open, high, low and close) Automatically as month change to next one (I don't want to manually change the cell range for Max function as and when month changes).