google sheet query to output only rows with 2 matching columns

Viewed 19
1 Answers

try:

=FILTER(A2:E, B2:B=E2:E)

or:

=QUERY(A:E, "where B=E", 1)

enter image description here

Related