Using query in google sheet to call certain rows

Question

Hi everyone,

I want to get all the rows where A=1, A=2. The query is very simple but I'm not sure why there is no output. I guess is the problem of the format for column A but I'm not sure what should I change in my formula so that the formula can work. Appreciate any help or advice!

You could also try =QUERY(A3:C,"Where A matches '1|2'",0), or QUERY(A3:C,"Where A matches '[12]'",0) — JvdV
– JvdV, Commented May 23, 2022 at 9:22

JPV · Accepted Answer · 2022-05-23 06:48:44Z

3

A can't be both: 2 and 1. Instead try

=query(A3:C, "Where A = 2 or A = 1", 0)

answered May 23, 2022 at 6:48

JPV

27.4k4 gold badges37 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

weizer Over a year ago

Thanks, I didn't notice I make the mistake there. Thanks!

Tom Sharpe · Accepted Answer · 2022-05-23 07:16:05Z

2

It should have been OR not AND - it's impossible for any row in a particular column to have two values simultaneously:

=query(A3:C,"select * where A=1 or A=2",0)

edited May 23, 2022 at 7:16

answered May 23, 2022 at 6:53

Tom Sharpe

35.1k5 gold badges29 silver badges47 bronze badges

Comments

Harun24hr · Accepted Answer · 2022-05-23 08:13:15Z

2

QUERY() is good choice. You can also use FILTER() function like-

=FILTER(A3:C,A3:A>=1,A3:A<=2)

answered May 23, 2022 at 8:13

Harun24hr

38.1k6 gold badges24 silver badges47 bronze badges

Collectives™ on Stack Overflow

Using query in google sheet to call certain rows

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related