WHAT IS ADVANCED FILTER? Excel Advanced Filter – as the name suggests – is the advanced version of the regular filter. You can use this when you need to use more complex criteria to filter your data set. EXCEL ADVANCED FILTER (Examples) EXAMPLE 1:Extracting a Unique list You can