Could you please provide guidance on how to edit data within Excel filtered results? I'm interested in learning methods to manipulate and update data while working with filtered views in Excel. Any assistance or instructions you can offer would be greatly appreciated. Thank you!
@tutsecret499
Жыл бұрын
Is there a way to pick these criteria via combo box instead of typing because sometimes there are many criteria. Let's say I have to filter either Positive or Negative or No showed or Not tested or Refused test. Thank you for your concise video.
@Luciano_mp
Жыл бұрын
I like filter, good exemples, Thank you!
@datauntelligence
Жыл бұрын
Excellent, glad it was able to help
@chica1111chica
5 ай бұрын
Saved my life I was looking for this tut for hours
@datauntelligence
5 ай бұрын
Yes!! Glad you found my vid, and that it helped you out. I really like the filter function
@bilalgulmemmedov2979
7 ай бұрын
Hello, how to filter if it contains the value or name when we put two ages? for example in FILTER(AND) page you give two ages and it show all but i need it to filter only specific name.
@artemike
5 ай бұрын
how can i have more than one word in the "if contains example)? I am guessing you need to combine filtering word A, word B and the OR function somehow ? Like, in your example how can I filter results from two different states ?
@LourinDoss
7 ай бұрын
Great video, thank you!
@datauntelligence
7 ай бұрын
Glad you enjoyed. Thanks for the comment.
@wohooky1
Жыл бұрын
What about filtering if it DOES NOT contain a text, can we do that? Thanks for the video!
@datauntelligence
Жыл бұрын
Good news. A video with filter(does not contain) is available. kzitem.info/news/bejne/tJqLt6eEqId-naA
@catboy721
Жыл бұрын
So, we can also send a man to Mars but we really STILL can’t filter on multiple tables or in a table separated with blank rows? I have colleagues who love to stack tables or they use header rows or leave blanks. Can I use filter to get around this or does the data set need to be contiguous? Thx.
@priyeshsanghvi8424
Жыл бұрын
Even better.....if data is spread across multiple sheets :-kzitem.info/news/bejne/oqtj0GSvrXeieWk
@nathandiaz3446
8 ай бұрын
Well once you wake up and realize the moon landing was fake it starts to make more sense.
@kaylak08
Жыл бұрын
This is so helpful, and I'm getting closer to what I need, but I'm hoping for something pretty complex. Is it possible to search for results across multiple columns? I would like for my "search field" (H1 in your example) to be able to search across multiple columns of data. I've tried entering "A:D" in place of "D:D" in the search portion of the formula, but get #VALUE! when I do that and I tried "A:A*B:B" and so on, but then get "Nothing" and I'm stumped.
@datauntelligence
Жыл бұрын
Im not exactly sure what you're trying to do, but maybe the (OR) version of this filter will work. Instead of filtering A:D, you might have to do a longer formula. For example filter column A:A by h2 OR column B:B by h2 OR column C:C by h2. Use the OR filter example from the video and combine using the + symbol.
@davidabuang
Жыл бұрын
Here’s one way of performing a keyword search across multiple columns… =FILTER(A2:E1000, BYROW(A2:E1000, LAMBDA(row, COUNTIF(row, H1)))) The beauty of this method is that you can perform any type of search by using wildcards. For example, in cell H1 you could input: [1] Eric (equals “Eric”) [2] San* (begins with “San”) [3] *ez (ends with “ez”) [4] *cali* (contains “cali”) [5] ???? (is four characters long) I only recommend this with small to medium size data sets (not entire sheet columns like A:E), as the BYROW function calculates row by row and will perform slowly on larger data sets.
@datauntelligence
Жыл бұрын
Thanks for the insight. I love being able to mix and match formula to get what you need.
@tutsecret499
Жыл бұрын
How about if I want this criteria to filter only the dates Opened Case column that is Today()-90. The sheet has 4k rows. Example: Today a nurse was assigned to a Case and she has 90days from today to give diagnose. So if Diagnose column is blank means the nurse did not provided yet the diagnose. So I have to filter all the cases that has blank diagnose counting 90 days back, there are many cases from 2023, 2022, 2021 including all the months and days and has not diagnose yet. So, show all the Opened Case Dates that Is null Or
@datauntelligence
Жыл бұрын
Thanks for watching... as part of the filter formula, (if the dates were in column A, rows 2 to 4000), I'd use (a2:a4000
@RareshCo
9 ай бұрын
What has to do isnumber formula i there?
@srinivasbonda2964
Жыл бұрын
But the formula is throwing only few values say, out of 10 only 5 values are appearing
@HealthyPetsdogs
11 ай бұрын
It is dynamic or static?
@datauntelligence
11 ай бұрын
Hey there, the result of these should update with changes in the data. Just make sure the cell ranges are large enough to capture when new data is added.
@hanyfahmy7021
Жыл бұрын
i need used filter function between 3 table at 3 different sheets .Sales 2022 .sales 2021 sales 2020.....thanxxx
@datauntelligence
Жыл бұрын
Hey, in case you are still trying to find a solution, I have released a new video on how to filter across multiple sheets. kzitem.info/news/bejne/oqtj0GSvrXeieWk
@nongnanzz362
10 ай бұрын
thank you
@datauntelligence
10 ай бұрын
Hey hey, no worries. Thanks for the message
@TheLooking4sunset
Жыл бұрын
Amazing
@datauntelligence
Жыл бұрын
Thank you! Cheers!
@calvinlong1321
Жыл бұрын
Everything? What about the =FILTER(array, {#,#,#,#,#,#}) # are 1 or 0
@ukkumar9971
Жыл бұрын
*plz Try to filter by city name*
@angelolim4595
Жыл бұрын
=FILTER() NOT WORKING ON MY EXCEL
@datauntelligence
Жыл бұрын
Hi there, this is a newer feature on excel and my not be available on some olders versions.
@tutsecret499
Жыл бұрын
It could be your data is dirty specially when copy or import from crazy programs. And some invisible/visible spaces caracteres are there and will interfere with your formula. You need to clean, field with wrong formats, etc. Need to clean your data first. I have 365 and it was not working the filter function. So I did some fresh data input from scratch in clean/virgem sheet and it worked, and then I will go back to my big data that I upload from the torture CERNER and start cleaning.
@sinsidet7137
Ай бұрын
If we want to find people who is over 50 old ?
@datauntelligence
Ай бұрын
Hi there. You can go to about 5:30 in the video. It shows you how to add 2 conditions. In your case, just include 1 condition where age>50.
Пікірлер: 38