Daily Archives: September 7, 2021

Say I have the following table, and I want to get all rows where COL2 = 2 and 3 A B 1 COL1 COL2 2 A 2 3 S 3 4 F 4 5 E 5 When I run the following formula: =FILTER($A$2:$B$5,(B2:B5=2)*(B2:B5=3),”No Match”) I get “No Match”. It seems […]