No video :(

NEW - EXCEL FILTER Function - Everything you need to know

Подписаться 6 тыс.

Просмотров 66 тыс.

50% 1

Learn how to use the new FILTER Function in EXCEL.
Filter data and tables using multiple conditions including:
Filter(AND)
Filter(OR)
Filter(CONTAINS)
File Location:
www.etsy.com/a...
Other Excel Playlists:
Extract SERIES (Numbers, Text, First Word, ETC) : • EXCEL - Extract ANY wo...
Pivot Table SERIES : • Group & Ungroup date f...
2 Minute Formula SERIES : • Add Months & Years in ...
Excel Chart/Graph SERIES : • Conditional formatting...
Excel Cleaning Data SERIES : • Wrapping Text in Excel...

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

8 янв 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 36

@chica1111chica 3 месяца назад

Saved my life I was looking for this tut for hours

@datauntelligence 3 месяца назад

Yes!! Glad you found my vid, and that it helped you out. I really like the filter function

@Luciano_mp Год назад

I like filter, good exemples, Thank you!

@datauntelligence Год назад

Excellent, glad it was able to help

@user-rr5dy9hk2k 3 месяца назад

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!

@LourinDoss 5 месяцев назад

Great video, thank you!

@datauntelligence 5 месяцев назад

Glad you enjoyed. Thanks for the comment.

@tutsecret499 11 месяцев назад

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.

@nongnanzz362 8 месяцев назад

thank you

@datauntelligence 8 месяцев назад

Hey hey, no worries. Thanks for the message

@artemike 3 месяца назад

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 ?

@bilalgulmemmedov2979 5 месяцев назад

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.

@TheLooking4sunset Год назад

Amazing

@datauntelligence Год назад

Thank you! Cheers!

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-SdUQsNoUMjk.html

@RareshCo 7 месяцев назад

What has to do isnumber formula i there?

@tutsecret499 11 месяцев назад

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 11 месяцев назад

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

@HealthyPetsdogs 9 месяцев назад

It is dynamic or static?

@datauntelligence 9 месяцев назад

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.

@srinivasbonda2964 Год назад

But the formula is throwing only few values say, out of 10 only 5 values are appearing

@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 11 месяцев назад

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 11 месяцев назад

Thanks for the insight. I love being able to mix and match formula to get what you need.

@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 10 месяцев назад

Even better.....if data is spread across multiple sheets :-ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Au-j0ytEqF4.html

@nathandiaz3446 6 месяцев назад

Well once you wake up and realize the moon landing was fake it starts to make more sense.

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Au-j0ytEqF4.html

@ukkumar9971 Год назад

*plz Try to filter by city name*

@calvinlong1321 Год назад

Everything? What about the =FILTER(array, {#,#,#,#,#,#}) # are 1 or 0

@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 11 месяцев назад

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.