Тёмный

Using the Excel FILTER Function to Create Dynamic Filters 

Technology for Teachers and Students
Подписаться 1,5 млн
Просмотров 290 тыс.
50% 1

Learn how to use the new FILTER function in Excel to create dynamic filters. These dynamic filters will update filter results immediately when data changes. My entire playlist of Excel tutorials: bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's the practice file that goes with this video: bit.ly/filterfunction #exceltutorial #excel

Хобби

Опубликовано:

 

31 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 79   
@mooserider1
@mooserider1 Год назад
Just found this and immediately liked and subscribed. Perfect for what I needed, and this is one of the clearest and most professional Excel (or other) tutorials I have ever seen. Also bookmarked URL to keep it and your channel in my knowledge base. Thanks for posting!
@BattleBladeWarrior
@BattleBladeWarrior Месяц назад
Holy cow, this was amazing. Not only did you explain it really well, but I appreciate we had a full uncut video to go with it. A lot of other tutorials I've seen use static images, so its not always easy to see where they went or what they clicked on, but you gave us full view of the entire process.
@tannerzornes4872
@tannerzornes4872 Год назад
Not often does the first suggestion on Google provide me exactly what I'm looking for. This tutorial is explained perfectly. Well done!
@mar29803
@mar29803 6 месяцев назад
Great video! I've been looking for a way to filter with an external cell reference. This works perfectly. Thanks
@knivessilva
@knivessilva Год назад
Very helpful. Just what I needed. Thank you.
@SeemaSharma-lj3cf
@SeemaSharma-lj3cf 3 года назад
Very useful feature . Thanks for the tutorial.
@danemmerich6775
@danemmerich6775 2 года назад
Great way to find specific info and as awlays a great tutorial.
@shoumikislam9242
@shoumikislam9242 Год назад
Just found what I needed, no chitchats, straight action.
@lavishjain0605
@lavishjain0605 2 года назад
This is so awesome . Thank you so much for this
@vasudevan-lg7lp
@vasudevan-lg7lp 2 года назад
Superb, I was trying to get this function for very long period, but I got now.
@chrishaley6082
@chrishaley6082 2 года назад
This explains perfectly!
@Nitens90
@Nitens90 8 месяцев назад
thanks, finally a video that goes straight to the point, almost shocking
@92417
@92417 3 года назад
Genius. Thankyou.👌
@lestariu509
@lestariu509 2 года назад
This is what I'm Looking for...thank you...
@user-bf2me4pe5t
@user-bf2me4pe5t 5 месяцев назад
Thanks, you've saved me hours!
@movethebaracka36
@movethebaracka36 3 месяца назад
GREAT JOB MY MAN ALWAYS ON TOP!!
@gvantsakvelashvili898
@gvantsakvelashvili898 Год назад
love it! thank u
@mohddanial8478
@mohddanial8478 Год назад
Thank god I found this video. Makes it much easier for my excel assignment :) - stuggling uni student :(
@bullbearjeff
@bullbearjeff Год назад
thank you for this
@binapark9208
@binapark9208 9 месяцев назад
This saved my day
@devramharak7934
@devramharak7934 Год назад
Well explained
@carltonbradley1192
@carltonbradley1192 2 года назад
Thanks!
@abigailkarr9305
@abigailkarr9305 3 года назад
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?
@MoatazMohamady
@MoatazMohamady 2 года назад
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)
@goodman-it2qy
@goodman-it2qy Год назад
Thanks.
@Thumper121234
@Thumper121234 3 года назад
Great as usual. How can you use the column if you add more data. Can you just name the column header?
@teoxengineer
@teoxengineer 3 года назад
Thank you for this tutorial. Can we use nested filter insede Filter function? =FILTER(FILTER(....,....,...),INCLUDE,IF_NOT_FOUND)
@melindaperrotta4931
@melindaperrotta4931 Год назад
Thank you for this video. I have a spreadsheet with multiple entries, but in which one column is only filled in upon completion of work. I would like to be able to filter for the negative or blank space in this column. i.e. See the uncompleted work. Is that possible?
@imVNUTZ
@imVNUTZ Год назад
Amazing video. Is there a way to also filter the data you pulled automatically? Like Alphabetize the list?
@soethein9525
@soethein9525 Год назад
Very Good and thanks you for your Video. Where can I download the Excel file?
@thefiveminutegamereview2117
Really clearly explained function, thank you. Is it possible to take it up another level and filter by multiple items for each category? For example filter for both PG and R rated movies?😀
@mythikry
@mythikry Год назад
Yes, assuming you use L1 for the second rating. "+" acts as an "OR" statement in the formula. Use =FILTER(A2:D43,(B2:B43=H1)*(C2:C43=K1)+(C2:C43=L1),"None")
@socarquality1912
@socarquality1912 Год назад
this function works only in excel 360 or 2021. :(( in 2016 version does not support the filter function unfortunetly
@sandeepnair8226
@sandeepnair8226 2 года назад
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
@hemmojito
@hemmojito 2 года назад
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?
@vickyfolonier112
@vickyfolonier112 10 месяцев назад
Is there any dynamic filtering option like this but that would keep the formatting of my data that's on the source table?
@nischalrai157
@nischalrai157 3 года назад
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
@BartoszXIV
@BartoszXIV 3 дня назад
Can you do "select all" or multiple in one of the filters?
@MahmoudShwky
@MahmoudShwky 2 года назад
What if i want to remove the rating from the filter function without rearranging the table. So it would be name catagory, and year
@richardbelu8252
@richardbelu8252 5 месяцев назад
Does this still work if you add new movies and you pass row 43. If not how would the formula change to allow adding for new movies to the list. Thank you
@vasudevan-lg7lp
@vasudevan-lg7lp 2 года назад
But how can we do filter the values in the Second filter based on the Values selected in first Filter?
@MegaSahil05
@MegaSahil05 2 месяца назад
NICE , INSTAED OF WRITING OR SELECTING FULL ARRAY YOU CAN ALSO NAME THE TABLE LIKE MOVIES AND GET THAT
@Ahmad-mq8xr
@Ahmad-mq8xr 2 года назад
Hi ! Do you think I can use FILTER inside Excel Table? I got SPILL error when try
@futuresuperstar4life
@futuresuperstar4life 2 года назад
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
@thewitt2890
@thewitt2890 3 года назад
Can I create a dropdown list that contains dropdown list? Your tutorials are the best
@agimasoschandir
@agimasoschandir 2 года назад
You can create a dynamic drop down list based on another drop down list
@sekan9304
@sekan9304 2 года назад
why i have no filter in my excel ? can i add this function ?
@Haid-Studio
@Haid-Studio Год назад
Hi, Can you tell me where I can find advance Excel?
@brunoyuske6267
@brunoyuske6267 2 года назад
Anyway to write back using this function?
@malikaamir6412
@malikaamir6412 4 месяца назад
Can we do this in excel 2013 bcz there is no FILTER function in it ?
@michaelpapa7854
@michaelpapa7854 3 года назад
What if I wanted to make the formula and/or?
@ArcOfTheCovenant
@ArcOfTheCovenant Год назад
Can u use this between sheets? Like if I have a table that take up an entire sheet. Can I make a new sheet that filters the data sheet? I'm having issues with this big time!
@ArcOfTheCovenant
@ArcOfTheCovenant Год назад
I call bulkshit! This does not work@!
@user-ns8pk2di1y
@user-ns8pk2di1y 10 месяцев назад
I get an error "FILTER has mismatched range sizes. Expected row count: 27682, column count: 1. Actual row count: 1, column count: 1" - any suggestions?
@BezUmiaru
@BezUmiaru 2 года назад
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.
@agimasoschandir
@agimasoschandir 2 года назад
As of now (2021) one cannot filter a table in place based on a cell value without VBA
@morgankigika494
@morgankigika494 3 года назад
Can u do something on if funtion kindly
@techteachersandstudents
@techteachersandstudents 3 года назад
Today's video, that I will post shortly, uses the IF function. Your timing in asking for this is perfect. :)
@NJtoTX
@NJtoTX 2 года назад
Mine only has FILTERXML.
@rajeshakkineni5127
@rajeshakkineni5127 2 года назад
👍👍👍👍👍
@MattaBinElba
@MattaBinElba 9 месяцев назад
What if your category column contains multiple categories, like "Comedy, Drama"
@clixx1431
@clixx1431 6 месяцев назад
then when typing the function, replace family with "Comedy,Drama" (with the quotations)
@roselerroldan2315
@roselerroldan2315 Год назад
I don't have filter formula.
@KK-jg3uc
@KK-jg3uc 3 года назад
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
@agimasoschandir
@agimasoschandir 2 года назад
You did not mention how much you would pay for such urgency
@user-bd7kl1xp2d
@user-bd7kl1xp2d 4 месяца назад
I am sorry, I tried this, but somehow, it's not working in my 365, but the video's explanation is great, it just does not work for me :(
@injesusnameiplay6074
@injesusnameiplay6074 2 года назад
the spread sheet doesn"t exist!
@zyclo
@zyclo 2 года назад
hi
@itzedomedo3721
@itzedomedo3721 2 года назад
hi
@jaimerosa1580
@jaimerosa1580 2 года назад
hey
@juliusschiffers7450
@juliusschiffers7450 2 года назад
@@jaimerosa1580 Hi
@sanmugamc6904
@sanmugamc6904 2 года назад
filter functions No my excel how to insert
@azizahjaafar913
@azizahjaafar913 3 года назад
.
@charlottek4157
@charlottek4157 2 года назад
me
@ArcOfTheCovenant
@ArcOfTheCovenant Год назад
This totally doesn't work. At all any of it. Not for me. And I have the filter function. I have office 360
@user-ox8bg6to5k
@user-ox8bg6to5k Месяц назад
AND and OR vs "*" and "+". Think of 1= TRUE and 0 = FALSE. 1*1 = 1 (TRUE AND TRUE = TRUE). 1*0, 0*1 and 0*0 all = 0 (TRUE AND FALSE, FALSE AND TRUE, FALSE AND FALSE ... are all FALSE) 0+1, 1+0 both =1 .. (TRUE OR FALSE, FALSE OR TRUE both equal TRUE) 0+0 = 0 ... FALSE OR FALSE = FALSE 1+1 = 2 ... well ... 1+1 > 0, so TRUE OR TRUE is TRUE (if you want to argue about 1+1 = 10, in binary, .. so just looking at the last bit, 1+1 = 0 .. then you are using XOR... but for Excel, 1+1 is non zero works well for "OR")
@vickynazi
@vickynazi 17 дней назад
cool ! very nice and explanatory video and very well explained !
@gerardvaneggermond2067
@gerardvaneggermond2067 Год назад
Hello sir, maybe you can help me I made code in Vba but it is long now I would like to make it smaller and maybe "loop" and "for loop" can help with that. Here part of the code: Application.ScreenUpdating = False If Sheets("Menu").Range("E2") = 1 Then Sheets("toplay1").Select Range("A1").Select ActiveCell.Formula2R1C1 = _ "=FILTER('S1'!R[1]C[1]:R[20]C[1],'S1'!R[1]C[1]:R[20]C[1]" "")" Range("B1").Select ActiveCell.Formula2R1C1 = _ "=FILTER('S1'!R[1]C[5]:R[20]C[5],'S1'!R[1]C[5]:R[20]C[5]" "")" The Range continues until "J1" you also notice that at "c[ ] each time 4 are added, that is because the search area moves 4 columns each time, if you can help me with this I will be able to continue with the rest I think, can you help me PLEASE What I forgot is that the number of rows being searched is 20.
Далее
How to Filter in Excel
16:22
Просмотров 427 тыс.
БИМ БАМ БУМ💥
00:14
Просмотров 3,2 млн
Using the New IFS Function in Excel
11:10
Просмотров 145 тыс.
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
Excel: INDEX and MATCH
10:47
Просмотров 196 тыс.
Make a Search Bar in Excel to Find Anything!
10:35
Просмотров 337 тыс.
Excel FILTER Function + Trick to Rearrange Column Order
10:17
Master the FILTER Formula in Excel (Beginner to Pro)
10:42
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Best exercises to lose weight ! 😱
0:19
Просмотров 10 млн
World’s Largest Jello Pool
1:00
Просмотров 93 млн