=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...