Autofilter on another autofilter?

  • I have an excel sheet, where I have first run an Autofilter that filters on one of the columns (column AD). After this I want to select the now filtered data and apply another Autofilter on the column V. I know I can just use more than one criteria in a given Autofilter, but I really want two layers of filtering, since there are 15 different filters on column AD and then there's supposed to be 3 different filters on coloumn V.


    One of the filters of column AD looks like this:



    Thanks in advance!

  • Just apply your filter to the entire range, then you can filter cumulatively on both columns.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why