Amazing Excel FILTER Function + Trick to Rearrange Column Order - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Manzoor
This is superb. But can Filter function be wrapped to a sumifs? Problem: I am working on a data set having Dates, Area, Customer, product and Amount. I want to filterout top Five Customers by Date and the problem here is all the fields have multiple Rows and i want to filter the customer after summing the corresponding amounts between dates. Is there a way to do this. Thanks
reply
This is superb. But can Filter function be wrapped to a sumifs? Problem: I am working on a data set having Dates, Area, Customer, product and Amount. I want to filterout top Five Customers by Date and the problem here is all the fields have multiple Rows and i want to filter the customer after summing the corresponding amounts between dates. Is there a way to do this. Thanks
reply
NiteLynr
I think it says something about me when you said 'I hope you're excited to give it a try- and I thought -Yes, yes I am-. Also, half-way through was thinking about a list of people who'd find great uses for it to share this with. Excellently presented as always, missed this one when it was released because we hadn't made the switch to 365 at the time.
reply
I think it says something about me when you said 'I hope you're excited to give it a try- and I thought -Yes, yes I am-. Also, half-way through was thinking about a list of people who'd find great uses for it to share this with. Excellently presented as always, missed this one when it was released because we hadn't made the switch to 365 at the time.
reply
Anthony
Hello Mynda thanks for another amazing tutorial, is this new trick is an alternative to using filter + xlookup-Match, since we primarly used that trick because we wanted to handle non contiguous data ? I'm refering to your xlookup video. Big thumbs up
reply
Hello Mynda thanks for another amazing tutorial, is this new trick is an alternative to using filter + xlookup-Match, since we primarly used that trick because we wanted to handle non contiguous data ? I'm refering to your xlookup video. Big thumbs up
reply
Tommy
Two major flaws with the FILTER function are you can't convert the source data into a table and you can't use wildcards to find partial matches. You can do this with the previous Advanced Function so it's not worth upgrading to the 365 version.
reply
Two major flaws with the FILTER function are you can't convert the source data into a table and you can't use wildcards to find partial matches. You can do this with the previous Advanced Function so it's not worth upgrading to the 365 version.
reply
Kerem
Hi Mynda. Video is great. ONe question. when I filter the table to a new sheet the colors of the cells disappear. how can we keep the colors or how can we add a criteria to chose only specific coloured cells.
reply
Hi Mynda. Video is great. ONe question. when I filter the table to a new sheet the colors of the cells disappear. how can we keep the colors or how can we add a criteria to chose only specific coloured cells.
reply
Shyam
Thank you. Great to know filter function based on data validation on various department. Can we include data validation list to select particular column (drop down list for Item, quantity and price).
reply
Thank you. Great to know filter function based on data validation on various department. Can we include data validation list to select particular column (drop down list for Item, quantity and price).
reply
Steve
Had to watch this twice to get my head around it, mainly because I've never used the CHOOSE function. This works great so will definitely be using it. Thanks for the video
reply
Had to watch this twice to get my head around it, mainly because I've never used the CHOOSE function. This works great so will definitely be using it. Thanks for the video
reply
Anastasi
Combination of FILTER and CHOOSE: the clearest equivalent to
sql sentence SELECT COLUMN1, COLUMN2, .... FROM TABLE WHERE COLUMN=-VALUE- !!!!!. Thankyou
reply
Combination of FILTER and CHOOSE: the clearest equivalent to
sql sentence SELECT COLUMN1, COLUMN2, .... FROM TABLE WHERE COLUMN=-VALUE- !!!!!. Thankyou
reply
Sean
It hurts to watch this video, seeing how incredibly useful this function is, knowing that I have to go back to Office 2016 at work.
reply
It hurts to watch this video, seeing how incredibly useful this function is, knowing that I have to go back to Office 2016 at work.
reply
Tommy
What advantage does the FILTER function have over the older Advanced Filter, which I feel is quicker and just as accurate?
reply
What advantage does the FILTER function have over the older Advanced Filter, which I feel is quicker and just as accurate?
reply
Add a review, comment
Other channel videos
