advanced filter ...filter OUT blanks

[daveyc18]

cant seem to make it work

 

[Joe4]

If you are using Excel 365, you can use the new FILTER function and exclude blanks, as shown here:

Filter exclude blank values

To filter out rows with blank or empty cells, you can use the FILTER function with boolean logic. In the example shown, the formula in F5 is: =FILTER(B5:D15,(B5:B15"")*(C5:C15"")*(D5:D15"")) The output contains only rows from the source data where all three columns have a value.

exceljet.net

 

[djclements]

If the cells are truly blank and do not contain zero-length strings, the criteria to filter them out is simply <>. If you still can't get it to work, please provide some sample data that shows how your data is structured and which columns you're attempting to filter by.