Using the Excel FILTER Function to Create Dynamic Filters
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
technology_for
I NEED HELP! PLZZ-
im a server and ive been working on an excel file to track my tips and sales percentages tip outs etc, it's very complex and im completely new to excel so it took me like two months.-
i'm trying to recreate an app that i was using but doesn't track enough details.-
in this app there are tabs on top for sorting the data yearly, monthly, weekly and biweekly and -all--
and then at the bottom you can toggle between all of the data with arrows, between the 2 arrows there are 2 dates based off of the filter (the corresponding dates of the month, the week etc) but youre not limited to just -this month- and -last month-, but you can continue to toggle between all months by clicking the arrow.-
i've tried with slicers and it kind of works but not as efficient or specific as i'd like it to be-
PLEASE TELL ME if you think that is at all possible on excel
reply
I NEED HELP! PLZZ-
im a server and ive been working on an excel file to track my tips and sales percentages tip outs etc, it's very complex and im completely new to excel so it took me like two months.-
i'm trying to recreate an app that i was using but doesn't track enough details.-
in this app there are tabs on top for sorting the data yearly, monthly, weekly and biweekly and -all--
and then at the bottom you can toggle between all of the data with arrows, between the 2 arrows there are 2 dates based off of the filter (the corresponding dates of the month, the week etc) but youre not limited to just -this month- and -last month-, but you can continue to toggle between all months by clicking the arrow.-
i've tried with slicers and it kind of works but not as efficient or specific as i'd like it to be-
PLEASE TELL ME if you think that is at all possible on excel
reply
education
Hi, Can you please reply me with the formula for -pulling the data from 3 workbooks to 1 workbook and want a functionality where the column headers should not be dependent on column no. such as A1,C1 which means data can be fetched using the column header name-.
Also, I want 1 more feature while fetching the data to new one that I am able to view the full details when I type particular employee ID on the table .
It is urgent, so please answer with formula or give me some reference.
Thank you
reply
Hi, Can you please reply me with the formula for -pulling the data from 3 workbooks to 1 workbook and want a functionality where the column headers should not be dependent on column no. such as A1,C1 which means data can be fetched using the column header name-.
Also, I want 1 more feature while fetching the data to new one that I am able to view the full details when I type particular employee ID on the table .
It is urgent, so please answer with formula or give me some reference.
Thank you
reply
hemmojito
Yes but can you filter partial matches? For example movies with the letters -ate- in it?
It should show for example -Kate and Leopold- but also -Darling I ate the children- (bear with me).
So a dynamic filter that finds partial matches in a list of text entries.
Is there a combination of functions that can accomplish that?
reply
Yes but can you filter partial matches? For example movies with the letters -ate- in it?
It should show for example -Kate and Leopold- but also -Darling I ate the children- (bear with me).
So a dynamic filter that finds partial matches in a list of text entries.
Is there a combination of functions that can accomplish that?
reply
Abigail
LOVE this video!! What if you want movies to have multiple categories? If for example I wanted Back to the Future to fall under adventure and sci-fi; d I need to create a new column in my data set for each different category, or could I make a comma separated list for the categories?
reply
LOVE this video!! What if you want movies to have multiple categories? If for example I wanted Back to the Future to fall under adventure and sci-fi; d I need to create a new column in my data set for each different category, or could I make a comma separated list for the categories?
reply
Nischal
when we dont have any data in rating then it shows none, it there any option that i would like to keep rating formula but choose sometimes to unfilter it, still expect the data to show as normal (like previous), i want rating to keep optional
reply
when we dont have any data in rating then it shows none, it there any option that i would like to keep rating formula but choose sometimes to unfilter it, still expect the data to show as normal (like previous), i want rating to keep optional
reply
BezUmiaru
How to make a filter based on the text typed in a separate cell that filters the original table rather than creates a separate table with results? If possible, with functions not VB.
reply
How to make a filter based on the text typed in a separate cell that filters the original table rather than creates a separate table with results? If possible, with functions not VB.
reply
Sandeep
Sir How would be the syntax, if one particular Genre falls under 2 or more categories, For eg. if Big Fish comes under Drama, Musical & comedy at a time...Thankyou
reply
Sir How would be the syntax, if one particular Genre falls under 2 or more categories, For eg. if Big Fish comes under Drama, Musical & comedy at a time...Thankyou
reply
Moataz
Thanks that was what I'm searching for, I just crate a new sheet for filtering ( I have one for data and another for filtering only)
reply
Thanks that was what I'm searching for, I just crate a new sheet for filtering ( I have one for data and another for filtering only)
reply
Mahmoud
What if i want to remove the rating from the filter function without rearranging the table. So it would be name catagory, and year
reply
What if i want to remove the rating from the filter function without rearranging the table. So it would be name catagory, and year
reply
Add a review, comment
Other channel videos
