Search code examples
excelexcel-2013

Advanced filter that compares multiple columns

I have a table.

      A    |   B         |   C         |   D         |   E   
 1    ID   |   Value 1   |   Value 2   |   Value 3   |   Value 4
 2    1    |   15        |   7         |   18        |   12
 3    2    |   6         |   19        |   11        |   20
 4    3    |   24        |   10        |   12        |   9
~plus about 10,000 more

I trying to create an advanced filter that shows results where Value 1 > Value 2 > Value 3 > Value 4. Can't wrap my head around the criteria table.

Solution

  • Add a new column F, then type this in F2

    =AND((B2>C2),(C2>D2),(D2>E2))

    copy and paste in the rest of the column F3..F10000

    now, create a filter for column F