Forum Discussion
Filter Function Only Showing Chosen Columns using Match
Hi ligg_1
Could you try any of the following:
=MATCH(N8:Q8,StakeholderCommPlan[#Headers],0)or
=XMATCH(N8:Q8,StakeholderCommPlan[#Headers])https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a: default value for 3rd optional arg. (match_type) is 1
https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312: default value for 3rd optional arg. (match_mode) is 0
If none of the above fix the issue please attach a sample workbook to your next reply - Thanks
Hi ligg_1
Could you try any of the following:
=MATCH(N8:Q8,StakeholderCommPlan[#Headers],0)or
=XMATCH(N8:Q8,StakeholderCommPlan[#Headers])
https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a: default value for 3rd optional arg. (match_type) is 1
https://support.microsoft.com/en-us/office/xmatch-function-d966da31-7a6b-4a13-a1c6-5a33ed6a0312: default value for 3rd optional arg. (match_mode) is 0
If none of the above fix the issue please attach a sample workbook to your next reply - Thanks
Thanks! The first option worked!
Do you know if it is possible to use the SORTBY function here to sort by "next communication date" and then "next communication responsible party" (or at a minimum "next communication date")? I am not able to figure this out.
- I'll (or someone else) be glad to have a look to your SORTBY follow up question but please do 2 things if you don't mind:
- Open a separate discussion
- Attach your workbook (remove sensitive data if any) to this new discussion as it very very difficult to work with pictures only given the length of your formula
Thanks
