Excellent video by an excellent teacher indeed! The simpler the better... this teacher has put a lot of education in a few steps which can not get any simpler !
Thank you so much, sir, for teaching this such a nice concept. but I want to know one more thing that how to do the same thing if data are in different workbook or worksheet and data are given in horizontally.
Thanks for your feedback. I will check it out and see if I will make a video around this. Check Excelator.tv (same as ua-cam.com/play/PL7mNAQHLbrTvKyYPyVJe2bQ3y3uglegNE.html) for any future Excel related content. As of this year, this channel will just output German content.
Does this work horizontally? i have a pivot table that continues to grow to the right. i have been asked to create to date totals and the pivot results actually go beyond that so i have grand totals, but i need the running total to date. Plus, i have to sum every 4th cell. This is a more advanced ask. Hmm. i think i will use a SUMIFs formula for this, at the source import. i can use your vid for another spreadsheet I have though. i have a downward results sheet for my blood pressure and want a running 5 day or 10 day avg. this works for that. thnks.
How to make this into a moving last 5 reference .... for example if someone has new data coming in and they add rows so will the last 5 move accordingly down to represent the last 5 ....
Thank you for this video, exactly what I needed!
Excellent video by an excellent teacher indeed!
The simpler the better... this teacher has put a lot of education in a few steps which can not get any simpler !
Thank you very much!
THANK YOU Z ... you are the best teacher
Very nice video and excellent explanation. Thanks
Thanks you so much ...
Wauuu.... you gave the simplest method. Thanks
Glad it helped
Thanks!
Excelente!!! Obrigado.
Thank you so much, sir, for teaching this such a nice concept.
but I want to know one more thing that how to do the same thing if data are in different workbook or worksheet and data are given in horizontally.
Thanks for your feedback. I will check it out and see if I will make a video around this. Check Excelator.tv (same as ua-cam.com/play/PL7mNAQHLbrTvKyYPyVJe2bQ3y3uglegNE.html) for any future Excel related content. As of this year, this channel will just output German content.
Does this work horizontally? i have a pivot table that continues to grow to the right. i have been asked to create to date totals and the pivot results actually go beyond that so i have grand totals, but i need the running total to date. Plus, i have to sum every 4th cell. This is a more advanced ask. Hmm. i think i will use a SUMIFs formula for this, at the source import. i can use your vid for another spreadsheet I have though. i have a downward results sheet for my blood pressure and want a running 5 day or 10 day avg. this works for that. thnks.
How to make this into a moving last 5 reference .... for example if someone has new data coming in and they add rows so will the last 5 move accordingly down to represent the last 5 ....
Hi, if instead of having the turnovers in a column but in a row, how can I calculate the last cell and the first cell?
Not that I know of
if you are using new excel sheet do not use [;true] in average column
gone....