FILTER FORMULA - does NOT contain - EXCEL

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

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

50% 1

Learn how to use the new FILTER Function in EXCEL to include everything that DOES NOT CONTAIN your specified text.
File Location:
www.etsy.com/a...
Other Filter Function Videos:
Filter Across multiple sheets - • Excel FILTER FUNCTION ...
Filter (AND), Filter (OR) - • NEW - EXCEL FILTER Fun...
Filter (Contains) - • NEW - EXCEL FILTER Fun...
Filter (Rows) & (Columns) - • EXCEL Filter Rows & Co...
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...

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

11 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Man 8 don't have this formula in excel 2016 how could I add it? With or without macro VBA

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

Not working in Office 365. Also Can I use instead of all this? Because still it is not working.

@iitomo0807 Год назад

I needed it for my work! Thanks!

@datauntelligence Год назад

Great, happy this one came in useful.

@DhirajWagh-jq9lv 3 месяца назад

Thank you !

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

No problem. Thanks for enjoying and leaving a comment.

@diceyDM 10 месяцев назад

How would you do that for many many different values? Ie i dont want ohio, or cal, or somthing else/

@theruizmortgageteam2736 10 месяцев назад

Yes, multiple values would be of great help!

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

I have same Q too.. how can we handle multiple values pls?

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

Hi, thank you for the video, very useful. Is there a way to Filter only customers that have certain products. E.g Customer 1 has Product A & B, Customer 2 has product A & B but Customer 3 has product A, B & C, I need a list of customers that only have Product A & B, so should not return Customer 3. Any guidance would be useful. Thanks, Steve

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

Hey , thanks for watching. It looks like you might need a multiple filter(or/and) combinations. This video will show you a couple of combinations that might help you build your formula. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-EXF1ewsrGfU.html