User Profile
MilExcelGuy
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Excel Filter using multiple columns as source data
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.539Views1like0Comments
Groups
Recent Blog Articles
No content to show