How to filter rows for blanks in different columns in excel

preview_player
Показать описание
How to filter out rows with missing data in multiple columns in excel
Helper column
=COUNTBLANK()
=COUNT()
=COUNTIF()
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelformulas

Microsoft Office 365, Beta Channel, Version 2102
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
Рекомендации по теме
Комментарии
Автор

Even though this didn't address my immediate issue, it was very helpful. You also explained the "COUNTIF" much more effectively than other places I've searched. Thank you.

DivaInTheWoods
Автор

You Ma'am, have changed my life. thank you!

anonymousmortal
Автор

I learned a few good tips and it was a very easy-to-understand presentation. Thank you 🙏

xgalaxyone
Автор

Thank you so much! This was just what I needed!

Noctarc
Автор

nice vid!! even tho i didnt understand at all excel hard for me :'( lol

oussamalasfer
Автор

a short way is to use =filter(array, criterion, A:A<>"")

amitkumarsingh