Forum Discussion
Solved
Filter Function Only Showing Chosen Columns using Match
Hello - I am trying to replace the column numbers in the {} with a match function referencing the headers from the source table but the formula is spitting out 0. Initial formula with {} ...
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
- 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