Staggered filter on Excel


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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top