Every time I watch one of your videos I'm amazed at the power of Excel and at your brilliance as an Excel(lent) user! Truely inspiring videos. Thank you for all the effort you put into making these videos.
@MyOnlineTrainingHub2 жыл бұрын
Wow, thank you for your kind words, Russell!
@IvanCortinas_ES2 жыл бұрын
Very brilliant use of the MEDIAN formula. Thank you very much Mynda!!!
@MyOnlineTrainingHub2 жыл бұрын
Glad you liked it, Ivan!
@perthling2 жыл бұрын
Years spent creating "if greater or equal to one date AND less than or equal to another date" formulas... solved with some creative thinking to use the median function. Sweet. Putting that in my toolbox. 😀
@merrillmchenry14509 ай бұрын
A long overdue "Thank you" for all the great videos and projects you post. THANKS and great job!
@MyOnlineTrainingHub9 ай бұрын
Very kind of you 🙏😊
@user-ct7nu1ly9z Жыл бұрын
Amazing video! Answered my question while teaching me a neat trick for cumulative formulas. Thank you.
@MyOnlineTrainingHub Жыл бұрын
Great to hear!
@Excelambda2 жыл бұрын
Great video!! A single cell formula for entire result array, 3 rows: dates sequence, total days, cumulative: =LET(sd,Table1[Start Date],ed,Table1[End Date], m,MIN(sd),x,MAX(ed), s,SEQUENCE(,x-m+1,m), a,(sd=s), b,BYCOL(a,LAMBDA(x,SUM(x))), t,SCAN(,b,LAMBDA(v,i,v+i)), VSTACK(s,b,t) )
@Excelambda2 жыл бұрын
Same formula without the new functions: =LET(sd,Table1[Start Date],ed,Table1[End Date], m,MIN(sd),x,MAX(ed),r,ROWS(sd), c,x-m+1,q,SEQUENCE(,c),s,q+m-1, a,(sd=s), b,MMULT(SEQUENCE(,r)^0,a), t,MMULT(b,--(SEQUENCE(c)
@MyOnlineTrainingHub2 жыл бұрын
Thanks for sharing!
@KV21A2 жыл бұрын
More than I expected Mynda. Great Video
@MyOnlineTrainingHub2 жыл бұрын
Great to hear!
@sachin.tandon2 жыл бұрын
Great work Mynda! I'm sure there are different ways of doing this. For the formula, so they spill, you could experiment with using the new BYCOL, BYROW, VSTACK, SCAN, AND LAMBDA functions (e.g. for the cumulative sum formula). Also, for if a date falls within two dates, you could use this, so it still spills as an array, of 1s and 0s (no need to drag the formula to the right): =LET( start_date,$C3,end_date,$D3, date_heading_array, F2#, date_matrix, (date_heading_array >= start_date) * (date_heading_array
@MyOnlineTrainingHub2 жыл бұрын
Cheers, Sachin! Indeed, you can use the new functions. Most people don't have them yet, so I went with something everyone can use.
@sachin.tandon2 жыл бұрын
@@MyOnlineTrainingHub My LET formula used really long before the new March functions were introduced I spent quite some time thinking about how I could avoid using Power Query using array functions, so all my tables would automatically and instantly update, without needing to run a workbook refresh E.g. my initial attempt here (warning, very long 'LET' formulae) >> docs.google.com/spreadsheets/d/1GCZ90nC-l8qlZrcyUfic-Shj0RcAE5xd/edit?usp=sharing&ouid=101105745586847596523&rtpof=true&sd=true With the new, new functions, though, its now become possible to do some really great things, in half as many lines of formula writing. Something I'm super grateful for! : )
@user-rl8yb7tb1k10 ай бұрын
Thank you.
@MyOnlineTrainingHub10 ай бұрын
You're welcome!
@chrism90372 жыл бұрын
Thanks Mynda, this was another great video!
@MyOnlineTrainingHub2 жыл бұрын
Cheers, Chris!
@mannyevalin83572 жыл бұрын
Thank you for sharing your expertise on the tool. Such a great help! 👍🏻
@MyOnlineTrainingHub2 жыл бұрын
Glad you enjoyed it!
@darrylmorgan2 жыл бұрын
Hi Mynda!Really Great Example...Thank You :)
@MyOnlineTrainingHub2 жыл бұрын
Thanks so much, Darryl!
@ThiagoPereira-qf6sv Жыл бұрын
Thaaaaaaaaaaaaaaank you for that! It is what I was looking for a long time!
@MyOnlineTrainingHub Жыл бұрын
So pleased I could help, Thiago!
@almezab8 ай бұрын
Amazing video , you are the best
@MyOnlineTrainingHub8 ай бұрын
Thanks for your kind words!
@AshwaniSharma-fc2nz Жыл бұрын
Very much helpful Maam
@SyedMuzammilMahasanShahi2 жыл бұрын
Thank you for this amazing share.
@MyOnlineTrainingHub2 жыл бұрын
Glad you liked it, Syed!
@RaffaeleLauricella Жыл бұрын
Amazing!!!! Thank a lot!
@MyOnlineTrainingHub Жыл бұрын
Glad you like it!
@mac23752 жыл бұрын
Always useful
@MyOnlineTrainingHub2 жыл бұрын
Great to hear, Marco!
@alvrodtal Жыл бұрын
Thanks a Lots!....
@MyOnlineTrainingHub Жыл бұрын
You're welcome!
@manasaraju85522 жыл бұрын
Thanks for sharing this mam
@MyOnlineTrainingHub2 жыл бұрын
My pleasure!
@ahmedtareq53422 жыл бұрын
This is great, just in time as I am trying to make somthing similar in power bi, BTW can you make a video how to do a project Gantt chart in power bi
@MyOnlineTrainingHub2 жыл бұрын
Hi Ahmed, you can probably get a Power BI custom visual for your Gantt chart.
@thomasfrohe29822 жыл бұрын
Love this. I do not see a link to the median video though.
@MyOnlineTrainingHub2 жыл бұрын
Oops, here it is: kzbin.info/www/bejne/pWe6XnSYpbGYp6s
@steinbeis53802 жыл бұрын
Great dear Mynda, greetings from Freiburg/Germany near Swiss Border. As an ecomist I believe in many occurrencies in nature and in economics following a s-curve. . By the Way in my works for my doctor degree, I found out that the use of energy in relation to the GNP follows during the development of countries economy an s-curve. Do you have an idea to use multidimensional data to show multidimensional s-curves similar a mountain or so? best wishes Wilhelm
@MyOnlineTrainingHub2 жыл бұрын
Hello! You could add more dimensions in the form of more series (lines).
@katykaboom2 жыл бұрын
Is it possible to create a timer in excel so after a certain amount of time(like seconds or minutes), if you have an image in a cell, the image changes to a different image after a set amount of time using only formulas(no VBA)? If possible the timer would be out of sight and you would only see the change in image.
@MyOnlineTrainingHub2 жыл бұрын
Not possible with formulas. You'd have to use VBA.
@neiltristanyabut9 ай бұрын
is there a way to do this with slicers but still in excel?
@MyOnlineTrainingHub9 ай бұрын
Slicers just filter data, so yes, you could filter the chart inputs with slicers.
@moto-camper8 ай бұрын
Can you help me out if my project is more than 12 months.
@MyOnlineTrainingHub8 ай бұрын
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@Buffalo188810 ай бұрын
When clicking my dates they appear as the cell I am clicking and not "Tabel1end date". What am I doing wrong?
@MyOnlineTrainingHub10 ай бұрын
I have my data formatted in an Excel Table: kzbin.info/www/bejne/eqaaZHaGprx6h9k
@jorisvandeBrande Жыл бұрын
Okay cool, But I wonder if this can't be done with Power Query.
@MyOnlineTrainingHub Жыл бұрын
I'm going to say no, because you should be returning tabular data from Power Query and this requires Pivoted data.
@khunkhang6118 Жыл бұрын
Hello Mynda, Thank you for the great tutorial on creating a Planned S-curve, The last part of the tutorial on Actual Cumulative Actual went so fast I did not get to understand the process, Do you have a tutorial for that part? Much appreciate
@MyOnlineTrainingHub Жыл бұрын
I don't have a separate tutorial, but if you download the example file from the link in the video description you can see how the data relates to the chart. If you get stuck, post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum