M
mikeshi89
Hi guys,
I was wondering if anyone has a idea on how to set up a staggered filter on excel. The goal is to filter the last column from highest to lowest, and the 2nd last column to start from where the last column's last number that is higher than 5, and moving on from there. The best way is an example:
My raw data table looks like:
Column Row 1 Row 2 Row 3
A 9 5 7
B 6 10 3
C 8 2 4
D 9 1 2
The end result:
Column Row 1 Row 2 Row 3
A 9 5 7
B 6 10 3
D 9 1 2
C 8 2 4
It ends up being a reverse ladder from highest to lowest greater than 5. Hopefully this is clear enough.
Currently I'm doing this manually by starting a new filter for each column.Any help would be great.
Thanks guys.
I was wondering if anyone has a idea on how to set up a staggered filter on excel. The goal is to filter the last column from highest to lowest, and the 2nd last column to start from where the last column's last number that is higher than 5, and moving on from there. The best way is an example:
My raw data table looks like:
Column Row 1 Row 2 Row 3
A 9 5 7
B 6 10 3
C 8 2 4
D 9 1 2
The end result:
Column Row 1 Row 2 Row 3
A 9 5 7
B 6 10 3
D 9 1 2
C 8 2 4
It ends up being a reverse ladder from highest to lowest greater than 5. Hopefully this is clear enough.
Currently I'm doing this manually by starting a new filter for each column.Any help would be great.
Thanks guys.