Mar 23 2022 12:12 PM - edited Mar 23 2022 12:14 PM
I have a production spreadsheet that has 6 different category labels (labeled 1 through 6) in a column. I want to extract row data for both single category and multiple categories to separate tabs. I can't seem to get the filter function to extract for more than one value per column.
Using =FILTER('Tab1'!A1:G100,'Tab1'!D1:D100=1 gets me every row that has a "1" in column D. But how would I write it if I needed to extract rows with a 1 OR a 2 in Column D? The hardest part of finding answers to questions like this is figuring out how to write the question.....intuitively I am asking how to write =FILTER('Tab1'!A1:G100,'Tab1'!D1:D100=1 OR 2 but that doesn't quite work lol.
Trying the multiple criteria option for filter but it doesn't work if I reference the same column twice. Appreciate the help!
~John
Mar 23 2022 12:26 PM
SolutionMar 23 2022 12:53 PM
Mar 23 2022 12:26 PM
Solution