Thank you Andrew. Because the data is in a Pivot style layout with month names along the header row. Month names are data and should really be in a column named 'Month Name' so the data could be filtered, sorted or calculated using the month.
It is gr8 video, i am wondering if a criteria to choose 3, 4 random months wich is not in sequence, how can we achieve the results. It would be great if you can able to explain.
Thanks, Shoaib. We could use a formula such as the following. This fomrula extracts 4 random months for summing. =SUM(CHOOSECOLS(tblSales,RANDARRAY(,4,2,13,TRUE))) RANDARRAY generates a random array of integers between 2 and 13 (Jan to Dec in the table), then CHOOSECOLS creates an array uses these integers as indexes of columns in tblSales. Finally, SUM does its thing.
Dear sir Thanks for this video Sir could you please help me 🙏 Sir i need to save and print the form it self on one page only Sir i try many times and i can't Sir what is the codes for this If you have vidio or link pls provided Thanks again
📚 Learn more than 150 Excel functions with 'Advanced Excel Formulas' - amzn.to/3Rg87Go
Very clearly and elegantly explained ❤👍. Thank you Alan.
Thank you Kebin.
Last 6 months average, median, percentile or even forecast ets function can be used via this method. Brilliant
Absolutely! Thank you for your comments.
I can already think of some applications of this for where I work. Excellent example to make us look outside our usual functions!
Fantastic! Thank you Tom.
Love these short "combination" formulas. Thanks!!!
You're so welcome! Thank you, Chris.
Thank you Andy for sharing that tip
No problem 👍
Great video as always. Video suggestion: explain the absolute and relative references in a formatted table
Thank you 😊
I have a video here ruclips.net/video/JjYbuHa1YYQ/видео.html
Absolute references in Tables are awkward.
More like these pls.... This is absolutely fantastic.... Thanks
Thank you 😊 I hope to deliver more.
Absolutely helpful, Thanks a lot.
You're welcome! Thank you.
Thank u Alan for this great video 📹 👍
My pleasure! Thank you Nader.
Loved this ❤
Thank you 😊
Good idea
Thank you.
Great vid; why do you say the data is in a terrible layout for data analysis?
Thank you Andrew.
Because the data is in a Pivot style layout with month names along the header row. Month names are data and should really be in a column named 'Month Name' so the data could be filtered, sorted or calculated using the month.
great as always. this time you did not attach sample data
Thank you Tanveer. The sample file has been added.
It is gr8 video, i am wondering if a criteria to choose 3, 4 random months wich is not in sequence, how can we achieve the results.
It would be great if you can able to explain.
Thanks, Shoaib. We could use a formula such as the following. This fomrula extracts 4 random months for summing.
=SUM(CHOOSECOLS(tblSales,RANDARRAY(,4,2,13,TRUE)))
RANDARRAY generates a random array of integers between 2 and 13 (Jan to Dec in the table), then CHOOSECOLS creates an array uses these integers as indexes of columns in tblSales. Finally, SUM does its thing.
@@Computergaga Thanks
Dear sir
Thanks for this video
Sir could you please help me 🙏
Sir i need to save and print the form it self on one page only
Sir i try many times and i can't
Sir what is the codes for this
If you have vidio or link pls provided
Thanks again
🙌🙌