Create a Dynamic Range in Excel... this is different!

Excellent! thanx Goodly

It doesn't work!

i am using a percentagerank function and my array keeps on changing basis the months and the market. Is there any way to make that dynamic coz right now I am manually updating it for every month

Clever, indeed! Thanks for sharing, Chandeep.

This was so clutch man.

Amazing👍👍👍👍👍

This was so helpful! I'm creating a ROI workbook and the number of "entities" to take into account varies so this helped me to create totals for specific line items across multiple, variable entities. Thank you!

Intresting really,Thanks for sharing

Why did you use ! mark?

You Fall me in Love with Your Channel, you Deserve Subscription, thanks 👍
I would Start Completing my Course of Power Query and PowerBI here For Sure, and If I Get Excel VBA And Python Tutorials Here it would be My Good Luck, Thanks for Solving my Problem Since Years ♥️

This was something totally new to me ! 👍👍

How to make chart draw from y min to y max. I need my y axis change accordingly

Brilliant boss

That's really smart. Thank you! I needed that tip! liked and subscribed!

Great Vid. Well explained and clear. Well done Goodly...

Very interesting. Love Excel and I bet the code for this great program would go to the moon and back!! Powerful!

Very elegant! Thanks for sharing.

Cool trick!

I love it !!! I used to use a blank row after the last record and a blank column after the last column, when I needed to insert rows or columns I would insert between the blank row/column and the last row/column with data.

Excellent

Very clever. Thanks for sharing.

Awesome!!!

Brilliant trick! Thank you!

Wonderful. Thinking out of the box

Good one sir 😈😈😈

Awesome!

Thanks for sharing.

Liked this relative cell referencing concept. Thanks for introducing this to us. Opens a new plethora of possibilities

Wonderful. Thinking out of the box

Thank you 😊

Really useful.