HI CHANDU ANNA NAMASTE. YOUR EXPLINETION IS VERY GOOD AND WHAT EVER MAY BE YOUR EXPERIENCE IS HIEGH IS UNDERSTAND IN YOUR WAY OF TEACHING. THANKS TO YOU ANNA.
Thank you for the content. Question, I'd like to know if I want to FILTER() the data that duplicate and shows sum of the QTY. How do I add countif(area, condition (sum of itself row > 2)) into filter function?
Hi sir, i was using the Filter function till yesterday, but iam not able to find these functions today, only FILTERXML is showing.. can you please help me with this.
@@chandoo_ To emphasize a particular point from that article, try to use Index() as much as possible for computationally heavy spreadsheets. The volatile flag for Offset() can have a huge impact on real-time responsiveness.
Here is one example with the employee data in the video. This filters everyone joined between 1 Jan 2018 and 31 Mar 2018. =FILTER(data, (data[Date Joined]>=DATE(2018,1,1))*(data[Date Joined]
I have been using these new functions in my Office 365 subscription over the last few months and they are amazing. However I recently received an update and now they are all unrecognized by Excel and preceded by "_xlfn" in all my formulas.
Hi Julia... You may have accidentally switched your Office update channel. Please go to File > Account and verify that you are on "office insider". The DA functions are currently available only this level but I expect them to be mainstream soon.
Hmm... I don't think you understand the *_implications_* of these array functions. Feel free to comeback once you have some real world needs to apply these formulas instead of manually sorting or filtering tables.
Excellent work sir , high quality
Speak Louder Sir, your way of explanation is very good.
Thanks for the video on Dynamic Arrays. It was short and to the point. Thanks.
Glad you liked it
HI CHANDU ANNA NAMASTE.
YOUR EXPLINETION IS VERY GOOD AND WHAT EVER MAY BE YOUR EXPERIENCE IS HIEGH IS UNDERSTAND IN YOUR WAY OF TEACHING.
THANKS TO YOU ANNA.
Thank you
Hey.. thanks Ben for the love and super.
Awesome Chandoo...Keep smiling!
Nice Introduction Chandoo!
Thank you
Awesome review! Thanks Chandoo!!
Glad you liked it!
🙏 Thanks Sir
Thank you for the content. Question, I'd like to know if I want to FILTER() the data that duplicate and shows sum of the QTY. How do I add countif(area, condition (sum of itself row > 2)) into filter function?
You are Awesome..!!, Thanks for the great explanation!
You are welcome!
Very nice! Thanks a lot for sharing this! These are really going to be game changers!
Thank you. DA formulas are one my new favourite in Excel.
great tutorial ♥
Thank you! 😊
Awesome explanation Chandoo. Another great work from you. Wondering, If you could share the spreadsheet with us.
Yes, sure. Please head over to the DA page - chandoo.org/wp/dynamic-array-functions/
Thank you!!
You're welcome!
Completed
Great info! Thanks!
Hi sir, i was using the Filter function till yesterday, but iam not able to find these functions today, only FILTERXML is showing.. can you please help me with this.
Sortbyandrandarray nhn use hoprha hai value error arha hai bar bar
without using filter option how could I get all the information like filter function. It will be great helpful to me.
Excel now has a function to do this. See my FILTER video for that. th-cam.com/video/JuTdj2j-9Kg/w-d-xo.html
@@chandoo_ sorry sir, I want this details or process without using filter function.
cannot we have a pivot table where we can see who are the employees report to IAN
Sir please make a video on OFFSET function and its variation with other most usable functions
Sure. I will add a video about this. Meanwhile, read up about the function usage here: chandoo.org/wp/offset-formula-explained/
@@chandoo_ To emphasize a particular point from that article, try to use Index() as much as possible for computationally heavy spreadsheets. The volatile flag for Offset() can have a huge impact on real-time responsiveness.
Great. Thanks. One question. How to extract (FILTER) data between two given dates?
Here is one example with the employee data in the video. This filters everyone joined between 1 Jan 2018 and 31 Mar 2018.
=FILTER(data, (data[Date Joined]>=DATE(2018,1,1))*(data[Date Joined]
@@chandoo_ Thanks Chandoo. Love you as always
I have been using these new functions in my Office 365 subscription over the last few months and they are amazing. However I recently received an update and now they are all unrecognized by Excel and preceded by "_xlfn" in all my formulas.
Hi Julia... You may have accidentally switched your Office update channel. Please go to File > Account and verify that you are on "office insider". The DA functions are currently available only this level but I expect them to be mainstream soon.
Audio is very feeble and not clear, please try hearing from youtube, you will understand
Sorry about that Thangavelu... Please use headphones. I had some audio issues for a few videos but that is no longer the case.
*Waste of time as you can do most of these functions in any table, and quicker*
Hmm... I don't think you understand the *_implications_* of these array functions. Feel free to comeback once you have some real world needs to apply these formulas instead of manually sorting or filtering tables.