Good day,
I have a data table on one tab. In this data table I have two columns with numbers in them Column I and Column J. I am using two filters to look for a specific number but want to combine these two formulas so that is the number does not appear in Column I it will look for it in Column J.
My two separate formulas are as follow:
=IFERROR(FILTER('Teller Stats'!$F$7:$L$1000,'Teller Stats'!$I$7:$I$1000=a3),"")
=IFERROR(FILTER('Teller Stats'!$F$7:$L$1000,'Teller Stats'!$J$7:$J$1000=I3),"")
I have a data table on one tab. In this data table I have two columns with numbers in them Column I and Column J. I am using two filters to look for a specific number but want to combine these two formulas so that is the number does not appear in Column I it will look for it in Column J.
My two separate formulas are as follow:
=IFERROR(FILTER('Teller Stats'!$F$7:$L$1000,'Teller Stats'!$I$7:$I$1000=a3),"")
=IFERROR(FILTER('Teller Stats'!$F$7:$L$1000,'Teller Stats'!$J$7:$J$1000=I3),"")