How to use advanced filter to remove blanks in excel

Показать описание

=A1＜＞"" To use advanced filter to get rid of blank cells make the heading in the criteria range a blank cell and then use the formula =A1＜＞"" which means is cell A1 less than or greater than two quotation marks i.e. is cell A1 not equal to a blank. Make the cell reference the cell in the top row of the column you want to filter. To filter more than one column us =AND(A1＜＞"",B1＜＞"")
--------------------------------------------------------------------------------
#exceltips #exceltutorials #msexcel

Microsoft Office 365, 2016, Office Insider, Version 1908
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE: