Excel Filter using multiple columns as source data

Copper Contributor

I have a data set Sheet1!A:O, that I need sorted and filtered.

The output data needs to be a matched in column (A) (unique key), filtered by the top 25 oldest records (M) (age), and also match records within another data set that has the top 25 $$$ owed (L) (owed). This will likely return less than 25 records, but I need this filtered and sorted descending by (L).  I've tried every iteration of vlookup, filter, match, take... no luck. What I though would work is this, as it seems most intuitive, but no-go.




What am I doing wrong? What can I do differently? Is Filter the correct function? I'm at a loss.

Thanks in advance for anyone who can help with this.

0 Replies