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?
@@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.
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.
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.