trying to get the Filter formula to pull data out of multiple sheets, and put it into one table, using this formula
=FILTER('sheet1:sheet2'!B17:H105,'sheet1:sheet2'!Z17:Z105=1)
but no matter what I try I can't get it to work.
any help ??
I should say using it on a single sheet works fine, it's trying to get multiple sheets to work together that's the issue
=FILTER('sheet1:sheet2'!B17:H105,'sheet1:sheet2'!Z17:Z105=1)
but no matter what I try I can't get it to work.
any help ??
I should say using it on a single sheet works fine, it's trying to get multiple sheets to work together that's the issue