12 Array Formula Tricks That Will Blow Your Mind! for Single Cell Spilled Sales Report. EMT 1707
HTML-код
- Опубликовано: 15 июл 2024
- Download Excel File: excelisfun.net/files/EMT1707....
Learn how to get the EOMONTH function to spill all the lower and upper limits for a month sales report. Then we build a single cell spilled sales report for month sales by Sales Rep. Learn about these functions: EOMONTH, CHOOSE, UNIQUE, SORT, SUMIFS, INDEX, IFERROR, SEQUENCE, ROWS, SUM and LAMBDA.
Solution comes from Bill Szysz.
Topics:
1. (00:00) Introduction to Bill Szysz trick.
2. (00:30) EOMONTH Trick to spill a rectangular range of upper and lower limits of dates for SUMIFS function criteria for a monthly sales report.
3. (00:41) Analysis Toolpak Addin Functions, like EOMONTH can spill results. Problem!
4. (01:22) Double Negative to trick EOMONTH.
5. (02:10) Function argument array operation in months argument of EOMONTH.
6. (03:22) CHOOSE to join a two column table with a one column table using array syntax {1,1,2}.
7. (04:45) UNIQUE to get unique set of records.
8. (05:00) LET function to define variables and make formula more efficient by avoiding repetition.
9. (06:24) SORT with [sort_index] argument with array constant {3,1}.
10. (07:00) SUMIFS and INDEX to create summary column for final report.
11. (09:57) CHOOSE to create final three column report.
12. (10:47) INDEX to create errors for total row.
13. (11:48) IFERROR to add total row.
14. (12:03) CHOOSE to create total row.
15. (13:00) Test formula with new data.
16. (13:27) Look at LAMBDA function to create function.
17. (14:21) Summary, Closing and Video Links
Other Related videos:
Basics of SUMIFS & PivotTables for Monthly Sales Report. Excel Magic Trick 1701.
Basics of Excel Spilled Array Formulas to create Monthly Sales Report. Excel Magic Trick 1702.
Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703.
Introduction to LAMBDA Excel Function. LET & LAMBDA together to make Single Cell Reports. EMT 1706.
Double MINUS??? I am going crazy! This solves a lot of problems with single cell arrays! Thanks to you and to Bill! Great video.
CU, Andreas
Yes, that is a great and useful trick, Teammate Andreas : ) : ) : )
I am addicted to your cool excel vids.
Not a bad addiction, as being awesome with Excel can get you paid!
Absolutely amazing! Enjoyed it to the core! Thanks a lot!!
Glad you liked it to the core : ) : ) : )
I've been using Excel since 1994, but still it is like an endless universe for me. And it is not (only :) because I am dumb.
Well, I consider myself dumb too. What you said was partially incorrect. You said: "it is like an endless universe for me". More correctly said might be: "Excel is an endless universe" or "Excel is an endless universe for users". Because it is nearly infinite. There is almost nothing it can not do. This is why the majority of business decisions are made based on results from Excel, and why Excel is the number 1 used business app in the world. We are not dumb because Excel is so wonderfully infinite, we are continually amazed by the new layers of what Excel can do each time we have a different problem to solve : ) : ) : )
Mr. Mike you are always the best
Always glad to help, Ismail : ) : ) : )
Job done. Mind blown... Awesome as always... Thanks Mike & Bill.
Go Team!!!!!
@@excelisfun Hi Mike - I revisited this again recently as I do with almost all of your content . I was performing an almost identical calculation over a different data set recently and I tried to do a COUNTIFS() over the array and couldn't get it to work - in your dataset I suppose the closest would be another column with a COUNTIFS() of the Sales Transactions against your Month Criteria - is there a ways to achieve that result ? Any help always appreciated .
@@TheCraigie007 What didn't work?
Loved the use of choose, informative and lived up the the channel name😊😊
Glad it all is fun, William!!!
Mind blower indeed, I have to watch it again and again to figure it out 👍👍
That is what is great about videos - you can watch again and again : )
Tricks + tricks + array functions = AWESOME! Thanks Mike and Bill for sharing!
You are welcome for the tricks and tricks : ) : )
Bill is always so creative with all these difference solutions that he comes up with. Thank him and thank you Mike. Stay blessed.
We do have an amazing Team!!! Go Team!!!!!!!!!!!!!!!!!!!!!
This is absolutely mindblowing! Thank you for sharing!
You are welcome for the mindblowing share!!!!!!
Mindblowing as usual, It's great to learn something new every week
Learn stuff is fun! Glad to help, 67duiker!!!!
Mind blowing videos from super mind blowing teacher...
Thanks, Teammate RRR!!!!!
As usual more great stuff. Thanks. I discovered the EOMONTH array argument problem the other day. This fixes that
That CHOOSE trick for the total row is neat. I am watching videos made by the Excel gods
That fixed that! (I love that!!!!)
Last row CHOOSE IS fun : )
I love the single cell reports! Thanks for sharing your knowledge!
You are welcome!
Prodigious video Mike, like all of them!
I hope to have the Lambda function available soon and test its full strength.
A pleasure, to be able to watch this video calmly several times. Pure caviar. Thank you very much Mike!
I love this: "Pure caviar"!!!!!
Crazy man, I love it
Thank to Bill and you,
Like always is fun 🤩 .
Yes, we have such a great and fun Team!!!!!!!
As good as it gets! Thanks sir!!
great video, can't wait to get the roll out of Lambda functions, this is very cool
Yes, LAMBDA cool : )
You are talented beyond believe.
Our Team is really wonderful : ) : )
Glad you like the videos and the teamwork, Hoi Yin Wan!!!
Just more than amazing. Thanks Mike
Just, you are welcome, K D : ) : ) : )
Boom!These Awesome Formula Tricks Really Did Blow My Mind...Thank You Mike And Bill :):)
You are welcome for the blown up mind, in a good way!!!!!!!!!!!!!!!!!!!!!!!!!!
It was amazing! Thanks for this film.
ZYou are welcome for the film, Jacek!!!
Great sir ...
Great explanation
That is awesome, thanks Mike!
Glad you like it, Teammate Chris : )
Are you kidding me? Boom, you just put amazing stuff from amazing people together.
Mr. Excel using array in Eomonth
Bill Szysz using Index for total
Excel is fun using choose({1,1,2}
You will kill me one day with these mind blowing tricks.
Really informative and appreciate it.
Thanks.
NO. No I will not do it, Software Train. I will not kill you someday!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! All the tricks will make you stronger and have the ability to have more fun with Excel : )
P.S. I learned {1,1,2} from cr gr0912 : ) : )
Majic that video was cool of full tricks! I’ll be using that emonth array trick tomorrow, thank you!
Yes, tomorrow is going to be EOMONTH awesome!!!!!!
This really mind blowing tricks
Glad to blow the mind in a good way, Ahmed!!!
Thank you Mike. Good to include totals at the bottom of dynamic arrays.
You are welcome for the fun and totals : ) : )
Awesome video!
WOW AMAZING SOLUTIONS!, This is best example of CHOOSE and EOMONTH functions, {1,1,3} and {-1,0} BRILLIANT.
We do have an amazing Team!!!!!!!!!!!!!!!!!!!!! Go Team!!!!!!
@@excelisfun 👍 You can find very useful formulas on my new RUclips channel. WELCOME Mike!
@@pedjanbgd4221 I just subbed to your channel : )
@@excelisfun Thanks Mike, the EAF-4 trick is coming soon!
Another great videos umbelivable what excel can do, to me power query & dynamic arrays are the revolution of Excel
Glad you like it, Mohamed : )
superb mike 👍🏻👍🏻👍🏻💯💯💯👌🔥🔥
You will have to pardon the loud thud of my jaw hitting the floor after watching this video, but what an amazing video!!
I am watching it all over again and taking notes to apply these techniques to my projects and reports.
Thank you so much for sharing!
No worries on the loud thud. It was a good sound : ) Yes, there are a lot of tricks. The video is always here for reference.
Magic Mike :) Thank you 👍
You are welcome, Davor : ) : ) : ) -- excelis "Magic Mike" fun ; )
Awesome Mike and Bill. That choose {1,1....} is world class trickery. One of those: "it shouldn't really work, but it does" type things. I'll be using that one.
Edit: also the double negative in eomonth is excellent. I was wrapping it in value(), which also seems to work, but I hadn't considered what the actual issue was, so it's great to know.
You are absolutely right about: "it shouldn't really work, but it does" , kind of like the IF({1},array) trick we used to do in INDEX to get it to make a function argument array operation in row_index, were we are like: "what, what!?!?!!?!"
So cool 👍
Glad it is cool for you!!!!
Hi Mike,
What blown my mind the most is you only use one cell for the whole table report.
That is amazing!
Thanks for showing us the right way to use Excel.
Thanks to Bill too.
Shah Alam, Malaysia
You are welcome! We have a great Team that we can all learn from : )
So sick
Awesome video and formula! Thanks Mike and Bill for another humbling, yet inspiring example of EXCEL wizardry and mastery! You guys always manage to break the mold. Thanks for sharing your knowledge :)) Thumbs up!! PS - The double unary trick is gold.. thanks for the reminder of that one. Also, want to copy that list of 2007 TookPak functions to remember when to use it!
I just add a worksheet tab in the download workbook for you with function names. I got the list from Mr Excel : )
@@excelisfun Excellent! Thanks very much. Will download again and add to my resource archive. Thanks for always being so generous with your time and help :)) Thumbs up!!
@@wayneedmondson1065 Go Team!!!!
Simple mnemonic for comma vs semicolon in hard-coded arrays:
comma for columns
semicolon for stacks
That is a great trick!!!
Boom Awesome video.Thanks to pivot Table Option.😉😂.This is tuff for me.
Yes, why NOT just use a PivotTable!!!!!!!!!!!!!!!!!!!!!!!
Awesome video, Mike! OMG! :-)
So many tricks!! Double negative to enforce vectorization on scalar arguments (that is a BIG one!), INDEX over-stretching, IFERROR+add.CHOOSE to fill up the gaps (where’s the time where adding total rows was hard. I remember it was not that long ago... ;-),...
WOW!...
That is suuuuuuch a funny and great point: back in the day when adding totals was hard... and now we have many methods: IF, IFS, SWITCH, IFERROR, IFNA, INDEX with too many... So many to CHOOSE from : )
@@excelisfun LOL!! :-)
@@GeertDelmulle Lucky us : ) What a Team!!!!!!!!!!!!!!!!!
Excel is full of surprises, like double negative converting impossible to possible
I love this: double negative converting impossible to possible : ) : ) : )
Great ! 💞
Glad it is great for you, usman!!!
Hi Mike
very useful video and very practical need everyone for every project ......very big thanks to share with us.
Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
Big You are welcome, ashish : ) : ) : ) : ) Thanks for the okays and flowers and cakes : )
You also get the first place trophy for first comment!!!
Mind blown.
Blown in a good way, though ; )
Thanks Mike!!! :) :) This is a great Video. I don't believe I've seen this trick in any of your previous videos and for the Months {-1,0}.....that was Mind Blowing!!! Amazing!!! .... Always Learning!!!
It has definitely been in many other function arguments, just not EOMONTH. BTW, I would not have made this video, unless you asked. But that downside is that it took two days to make and that means I am two more days behind on book lol
Glad that you are always learning, Formula Guy!!!! Me too!!!!!
@@excelisfun Sorry to have put you 2 days behind. Please do not make me feel Guilty :) :).......but I loved it. That was Monumental !!!!!!!
@@johnborg5419 No guilt, I had already set up the workbook to film this, but set it off to the side when LAMBDA came out. But with so many important tricks to share, I had to do it lol
@@excelisfun Never seem to get enough of this video. Watching it again and again and practicing. :) :)
Really good stuff learned a lot. One minor suggestion. Since you are reusing the second and third columns of the CR multiple times, I would make them into variables too.
I agree. That is a great suggestion. Bill Szysz said that he wanted to try and do it with only two variables, but than I changed it a bit, when I put the d, p, s variables in lol
Congratulations sir for 700k subscribers 🎉🎉🎉🎊👍
Thank you very much, Kamlesh : )
Hero.
Go Team!!!!
So much goodness in this! I'm still a bit overwhelmed by LAMBDA, but looking forward to GA so that I can slay the beast & start using it. LET has become my new best friend over the past couple of months. I'm developing a workbook now that will use EOMONTH, so this tutorial is very timely. (Funny how your videos always seem tuned in to my current or near-term needs.) But, the sleeper surprise in this tutorial is double minus. How did I miss that before today? It's a much simpler solution than the work-arounds I've been using. Thanks, Mike! And thanks, Bill!
LAMBDA is easy. The fact that you have mastered LET over the last few months - that is much harder than LAMBDA. Well, that is at least how I feel. I love to hear that LET has become your new best friend, and that EOMONTH and the double negative are so useful. I learn about the double negative for these rouge function only a few months ago from a Mr Excel video : ) Really, we are only bumping into new problems like these because spilled arrays are relatively new and we are all still getting used to it all : )
Apparently for EOMONTH and its sister functions "+" works just as well.
@@t.pigeon2384 and all the cousins too : ) Any math operations that will not change value should work, but -- tends to be fastest.
@@excelisfun You’re right - LAMBDA itself looks to be easy. What I meant to say was that your demonstrations of LAMBDA are overwhelming, especially the uber-complex single-cell formulas. Overwhelming, but also inspiring!
@@excelisfun good to know. Thanks.
I am going to have to "eat this elephant one bite at a time". This video is jam packed full of great information. Thanks Mile Bill J. and Bill S. for sharing.
By the way....is somebody procrastinating on writing an awesome book..... from BMX Sundays to writing the most complex single cell Dynamic array formulas using Let, Lambda, curly bracketsetc? Just kidding Mike... Enjoy your days and keep up the fantastic work, it is much appreciated.
The BMX is a Sunday morning few hour must to get exercise and fuel for the brain - so that is good for the book. However, producing videos is usually not good for the book writing because it takes so much time, at least one hour per minute to make a video. I really should just shut off making videos, but I feel obligated to make at least one video a week, I mean for almost 13 years I have been consistent with doing that. Thanks for noticing, Matt. And... You might be a mind reader: this video in particular took two days and gave me fits as I had to re-film many parts of it over and over... : ( and I knew before I started that I should not do this video and instead just write the book...
@@excelisfun It's all good Mike, I understand.... as I procrastinate from what I really need to be working on right now. I
@@mattschoular8844 : ) : ) : ) : )
@@mattschoular8844 Go Team!!!!!!
Thank you for sharing! Great as always!! May I have one question? I need to pull A Part with 20k, and in the inventory, there is A Part in 01/01/2021, 10k, in 01/02/2021, 5k, in 01/03/2021, 10k. So I need 10k, 5k and another 5k from the inventory. Is there a way by Array formula could pull out these three lines directly? I have hundreds of parts. Thank you!
Just when you think you're using array formulas like a pro! You find out this amazing mind blowing video to learn a loooooot about array formulas 😍😍😍😂😂😂
Mike, you really taught me in this video to stay humble and avoid ego with what I know 😂😂😂
Thank you for every single frame of this brain-feeding masterpiece!
You are welcome! I am like you too, Ali! I am just learning too. But together as a Team we can learn so much and keeping come back to videos like this to remind ourselves of these tricks. I do that too, I came back and watch later. The time hyperlink table of contents helps when I am using the video as a references for later. Have you seen the time hyper linked table of contents in Show More area?
@@excelisfun I do, and I like it sooo much... Not just an amazing video, but also an organized system where we always have the workbook to download and the time index for easier navigation! I really like it so much and always refer my friends and colleagues to Excelisfun whenever they ask me how did you learn excel 👍🏻
@@Ali.Mostafa Thank you so much for your support!!! I depend on Teammates like you : ) : ) : )
Great video, loved the IFERROR to get the total row. BTW did you realise you spelt 'argument' as 'argumnet'?
Nope. I am a terrible speller. I am dyslexic too. So when I spell words wrong I almost always can not see it. That is why I have soooooo many videos posted with miss spelled words. I depend on kind teammate like you to help me out : ) Thanks, Teammate darryl : ) :)
I have been working with excel for 27+ years and I just updated to office 365 and all this stuff in this video are ...
Seriously, are we still talking about excel? ;)
Damn it, I should have upgraded sooner.
Yes, the past 10 years of Excel history are profound. How we did things for 40 years is all different now. From Power Query, Power Pivot, DAX formulas, Power BI, Spilled Array Formulas, LET, LAMBDA and sooooo much more. It will take us a while to get used to it. i am working on a book that introduces all the new Excel for all the things we have done for 40 years. It will be out next year. I will also have a full free video class here at RUclips (starting to make next year) about how people like you and I who know the old Excel can use the new Excel with MUCH more efficiency and accuracy. It is taking a long time for the book, but next year...
@@excelisfun I barely can't wait for it.
I learnt a lot with your CTRL+SHIFT+ENTER book (I bought the green-yellow cover one) and made a big "revolution" at the office I work for, with all that functions and techniques you taught in that book.
So, a new "revolution" is about to come with that new book you will publish.
By the way, do you have any idea when we can pre-order it?
Thanks in advance.
A since 2013 fan boy. :)
@@vandalo7494 I am glad to hear that the green and yellow Ctrl + Shift + Enter book was so transformational!!! : ) My new book is about six months behind my original publish date, probably not out till next Oct 1. You can pre order at Amazon: www.amazon.com/Microsoft-365-Excel-Calculations-Analytics/dp/1615470700#:~:text=See%20this%20image-,Microsoft%20365%20Excel%3A%20The%20Only%20App%20That%20Matters%3A%20Calculations%2C,Insight%20Paperback%20%E2%80%93%20October%201%2C%202021&text=This%20is%20a%20book%20about%20Microsoft%20365%20Excel%2C%20or%20Excel%20365.
Hi Mike
Are we can use sumifs(sum_range, criteria_range, Index(--(Month(A1:A10)&Year(A1:A10),,1)) replaced of emonth function not working and this give #value!
Hi ExcelIsFun!
Mind blowing this trick: CHOOSE({1,1,2} ... ) !!!
But is not working when you try another order of columns... like CHOOSE({2,1,1}...), or put the two column array in different place of first one. Seems like kind of implicit intersection... do you know about some combination into CHOOSE for do it without referencing individual columns?
I try some option but are "big one": =INDEX(CHOOSE({1,1,2}... ), SEQUENCE(ROWS(range)), {3,1,2}). Blessings!
Yes, I can only get it to work from the front too. I like your comment that it works with implicit intersection. I had not thought of it like that before. I do not know how to use CHOOSE without referencing individual columns.
HI Mike. This was a great videowith a bunch of great tricks at the same time. Quick question: Is it possible to replicate this solution using sumproduct with dynamic arrays? Every time I try to use a sumproduct and dynamic arrays in the same formula , I always get an error...and i end up using SUMIFS with dynamic arrays instead .Have this happened to you? Thanks for posting
SUMProduct will always aggregate to one answer, like SUM function. It is not like SUMIFS that has a criteria argument that you can make a function argument array operation to spill many items.
Thanks for another great video. I notice that you did not include the header row in the LET formula. With a little twigging of the solution you can include every thing in the one formula:=LET(
h,{"Person","EOM","Sales"},p,SalesTable4[Person],d,SalesTable4[Date],s,SalesTable4[Sales],
pe,SORT(UNIQUE(CHOOSE({1,1,2},EOMONTH(--d,{-1,0}),p)),{3,1}),seq,SEQUENCE(ROWS(pe)+2,1,0),
ts,SUMIFS(s,p,INDEX(pe,,3),d,">"&INDEX(pe,,1),d,"
In other videos I included header row in formula, but because it is a hard coded value, it just seemed easier to just type it into formula. However, that also has it's drawbacks... Thank you for your formula that enhances the Team, ContentedSoul : )
I added your solution to the download workbook so other Teammates can benefit : ) Go Team!!!!
700 k 👍👍👍
Thanks!!! I just subbed to your channel : )
Hello. Could you please help me in finding a response to my inquiry that is how can i generate excel workbook from templates ? Is there any free add-on can help? Or something like that. Thanks in advance
I do not know how to do that, as I do not use templates. Try posting question here: mrexcel.com/forum
I worked on some ideas further. Here is a generalised solution for both unpivoted and pivoted summaries
>> drive.google.com/file/d/1GCZ90nC-l8qlZrcyUfic-Shj0RcAE5xd/view?usp=sharing
--> using LET, (hard part is appending arrays elements either sideways or vertically) - each LET can be wrapped in a LAMBDA to pass in
external variables - allowing for even greater solutions!
This is amazing ... but ... i'm still stuck in let function .
Sorry about the getting stuck... But at least the EOMONTH tricks are useful everywhere : )
@@excelisfun of course ... Everything is amazing
@@HusseinKorish : ) : ) : )
The worst thing is... As a cost cutting measure... Our company has moved from office 365 to office 2016... Bloody hell
It can be worst, look to our company, we have "365 Plus" but our IT is still blocking the rollout for array-functions-update.... 😢
@@RogerStocker lolll
That is terrible. Don't they know that the Excel 365 costs incur lead to revenue saving efficiencies !?!?!?:!?
@@RogerStocker That IS the worst : (
How could you cut cost if you have active 365 subscription, something doesn't add up.
Again a video after which I feel that I hardly know anything about Excel 😅
But we are all like that. None of us know much. That is why it is so awesome to be part of a team. Together we know much more : ) Go Team!!!
Very interesting, but not enough on HOW it works. Why does {1,1,2} work?
Well I do have over 3,500 videos and have explained the basics of array formulas in a number of previous classes, but {1,2,3} is an array constant that says please get the 1st, 2nd and 3rd values. In array syntax {} house the array, , indicates column, ; indicates row. So {1,2,3} delivers the three answers simultaneously across the columns.
its not working in my excel 2019 with your ref file eom function help! me
Microsoft did not put the spilled array functionality in Excel 2019. It is only in Microsoft 365 Excel.
I need advice on a project how can I contact you?
The best place for Excel questions is: mrexcel.com/forum
Hi, I found simpler solution, how can I send mine for your review?
Post formula here! There are a lot of solutions posted so far in the comments - join the Team, Soheil!!!!
There are also four other videos that have solutions posted in the comments, EMT 1701-1703 and 1705 : )
Can you post? We want to see : ) : )
=LET(url,"excelisfun.net/files/EMT1707.xlsx",lft,LEFT(url,5),IF(lft="https","Good Download","Download Problem"))
(Still the BEST Excel videos on RUclips!)
What did I just see?
Crazy Array Formula Fun. Plus this can be a one-stop shopping video spot for crazy array tricks that you can come back and watch regularly.
I hear you mike but that just sounds like a nightmare to audit those formulas.
I think it is always better to break down stuff like this or just create these reports with PQ, all you would have to do is update the source (or make it dynamic), this would still be simple for laymen.
This seems to be overly complicated and either for bragging rights or over complicate things to make it look harder.
The is some truth to what you say. But think about what Power Query does behind the scenes. The same thing. Let and then lines of code. The advantage to formulas is always only one thing: they are the only tool that updates instantly. And for some models that is mandatory. The advantage to LET is that you can define a single cell, and then with the new LAMBDA, you can make a re-useable function. For some models and situations, it is a dream come true. The other thing about LET is that is removes complex formulas with many formula elements that are repeated. All of this is not for all situations. But it does solve historically difficult situations in the worksheet. And for some people and some models it will be perfect.
is this overkill, is this unnecessary, dont know, looks cool, but kinda missed good old sumproduct magic
No worries, Excel is beautiful that way, if we want to use SUMPRODUCT, our dear Excel will let us : )
Hi Ozgur and Mike! Is it possible to replicate this solution using sumproduct with dynamic arrays? Every time i try to use a formula with sumproduct and dynamic arrays in the same formula , i always get an error...Have this happened to any of you?
@@jazzista1967 Sorry never tried.
Waste $$$ on the lottery?🤔 Watch your wonderful videos?🧐 So, the Lamda and Let function effects the sales report by .....
'Argument' lol
As I posted below:
I am a terrible speller. I am dyslexic too. So when I spell words wrong I almost always can not see it. That is why I have soooooo many videos posted with miss spelled words. I depend on kind teammate like you to help me out : )
lol
@@excelisfun amazing videos so grateful to see them :-)
@@gelert64 : )
Nobody tells How to calculate in Excel Step Up SIP Amount for a Target Corpus ?
Everybody tells big big things about Step Up SIP.
Can you at least tell how to calculate it in Excel with using a formula ?
This is all I know: ruclips.net/video/2uU63lhcIbI/видео.html
@@excelisfunThanks a Lot.
But I require vice versa, means, say Final Sum (Corpus to collect in 10 years) is $2,00,000 and I want to know monthly SIP with yearly growth of 10% ?
Can I use GoalSeek() function of excel to find exact value of Monly SIP amount, instead of trial and error method by so many iterations to find the Final Monthly SIP?
Please Guide.
Mind blower indeed, I have to watch it again and again to figure it out 👍👍
Thanks, Statistics Guy Ogwal : ) Isaac says Hi, BTW : )
@@excelisfun Hi Isaac, that's great, how old is Isaac now👏👏
@@ogwalfrancis 14 1/2 : )
@@excelisfun a grown up man nw, 👍👍👍
@@ogwalfrancis Not quite yet. He still has some fun kid years left. But then later he can have fun in the man years when he is graduated from college and has a good job and can fulfil his duties and responsibilities, then he can be man : )