Dynamic Spilled Arrays: Show All Formulas For All Columns in Cells as Auditing Trail EMT 1524

In this video learn how to take multiple columns filed with formulas and list all the formulas and the cell reference that the formula sits in in a Vertical Column with a single cell formula. See the Functions: ADDRESS, ROW, COLUMN, FOMULATEXT, IFNA and TRANSPOSE.
Full Lesson on these new Dynamic Arrays and new Excel Calculation Engine: Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516)

[rrrprogram]

Fantastic Your energy and enthusiasm towards Excel is none to anyone

[HusseinKorish]

Wow ... it spiled to the right too ...i did not expect that ... that's Great ... Thanks Mike

[utubeAgape]

Wow! This is excellent for creating an easy way for the boss to review reports before publishing! Saves a lot of time - not as much explanation required! Learning SO much from your channel and can’t thank you enough. The dynamic spilled arrays especially have been a great win at work👍

[ismailismaili]

God I can't stop watching your videos Mr. Mike you always give me all what i need

[johnborg]

Thanks for the nice morning Breakfast Mike :) :) Nice !!!

[tecwzrd]

Very helpful teaching tool! Thanks again for all the tips & tricks.

[DIGITAL_COOKING]

cool technics, I like the way you work with excel, and I'm waiting for new videos about MSPTDA series, please continue the series
it was great

[nsanch]

This is an excellent series Mike. Thank you so much for putting this together.

[harishpaldhir]

HATTS OFF SIR
PLEASE KEEP THIS WAY IN VERY ENERGETIC MANNER

I AM GREAT FAN OF URS 😇😇😇

[wayneedmondson]

Hi Mike.. nice.. love that TRANSPOSE to switch the orientation. Thumbs up!

[spilledgraphics]

Sweet stufff Mike !!!! amazing tip for documenting your model in Excel, thanks !!!!

[mohamedchakroun]

Nice trick from a briluant teacher :-)

[barttitulaerexcelbart]

This is again a new way of auditing as spreadsheet. May I challenge you (or any of your vieuwers)? would it be possible to do this for a whole sheet, in stead of a row? And then, would it be possible to show ony the unique values? and then delete anything that is between the brackets. So in the end you should have a list of all used formula's. Greetings Bart.... Have fun with thinking about this...;)

[dipkchopra]

Hi,
Thanks for all your videos.
I have one query and one request
Query: Can you create two dynamic array lists one below the other such that the second list begins immediately after the first ends. The first list has dynamic number of items.
Request: Can you start a poll asking how many believe that Microsoft should provide the new calc. engine to Office 2013 and Office 2016 users as well. You may then with the results persuade Microsoft to extend it to existing users as well.
Thanks

[imkuldeep]

Why is Ctrl+Shift+Enter not used? Sorry I could not get it from video...

[rostuff]

Great videos! I came across your channel (I subscribed) in search to a problem I have with sorting a table with a column containing drop lists in it. The column with the drop down lists WILL NOT sort! Is this an easy fix? There are column has drop down lists containing many different lists. Thanks!!

[kartickchakraborty]

Sir, for your kind information, after lots of trying, I've found a formula that helps solving this problem and dealing with these merge cells but when the destination data and their format are as same as source data. But if I change the destination data and their format, it won't give the right result. I'm attaching this finished file to your google+ account. Check this file, you'll understand everything. Please reply me sir. I'm your die hard fan.

[nboisen]

How would you do this without the new calculation engine? For example, Transpose will not work without "spill"...

[richardhay]

Will you do a video on SORTBY? Also do you know the ACTUAL reason MS developed SINGLE and what did they intend it to be used for? It appear so be a solution in search of a problem!