=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

SUBSCRIBE: https://goo.gl/c46YPs

Microsoft Office 365, 2016, Office Insider, Version 1908

IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
How to filter in excel 5 different methods    • How to filter in excel  5 different ...  
How to filter using vlookup in excel    • How to filter using vlookup in excel  
How to use vlookup to find the 2nd, 3rd or Nth match in excel    • How to use vlookup to find the 2nd, 3...