I have a pretty straight forward issue, this is my Formula:
=FILTER('Xero Report Paste Tab'!A7:N146,'Xero Report Paste Tab'!N7:N146 <0,'Xero Report Paste Tab'!N7:N146 > -30,REGEXMATCH('Xero Report Paste Tab'!A2:Z2,"Contact|Invoice Number|Total|Project Code"))
My issue is the mismatched ranges causing Greif, how can i pull only the columns with the headers i want while it also having met the first 2 requirements if not with this formula?
Any explanation is always welcome as i’m learning!
>Solution :
Can you test:
=FILTER(
FILTER('Xero Report Paste Tab'!A7:N146,REGEXMATCH('Xero Report Paste Tab'!A2:N2,"Contact|Invoice Number|Total|Project Code")),
'Xero Report Paste Tab'!N7:N146 <0,'Xero Report Paste Tab'!N7:N146 > -30)