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.