Forum Discussion
mattdparkeroutlookcom
Feb 22, 2022Copper Contributor
Filter Function with Lookup or second condition
I am looking to minimise the number of columns required for a filter function formula whereby a table is filtered by 2 conditions, one is date, the second is Account Type. I can get it to work if...
mattdparkeroutlookcom
Feb 22, 2022Copper Contributor
maybe this link is helpful, but I still can't figure i out...
https://techcommunity.microsoft.com/t5/excel/concatenating-arguments-in-the-filter-function/m-p/1426919
Does this help?
I was unable to find a combination that worked....
https://techcommunity.microsoft.com/t5/excel/concatenating-arguments-in-the-filter-function/m-p/1426919
Does this help?
I was unable to find a combination that worked....