Jul 24 2023 07:23 AM
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.
=SORT(FILTER(Sheet1!A:O,(sheet1!A:A=age!A:A)*(Sheet1!A:A=owed!A:A)*(age!A:A<>"")*(owed!A:A<>""),""),12,-1)
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.