I have row of six digit numbers where I want to filter rows containing exact numbers set. For example:


I want to filter 154935,154937 these numbers exactly. But am not sure how to do that on filter option.

This is just an example. I actually want to do the same from large column.

closed as unclear what you're asking by pnuts, jonsca Sep 13 '17 at 23:10

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Perhaps this answer is of use: webapps.stackexchange.com/a/42433/29140 – Jacob Jan Tuinstra Nov 5 '15 at 21:25
  • Filter View and checking those numbers as options would work as well. – Tom Woodward Nov 6 '15 at 2:32
  • order status changes everyday like packed, shipped, delivered, etc., for different orders. if I have to update it in the sheet, I need to filter those exact id but as of now am clicking one by one – Ted Nov 6 '15 at 14:30

I actually want to do the same from large row

I understand you have a large row of numbers that you would like to filter by. Perhaps your data is in columns A and B, and the cells C1:E1 are occupied by numbers like 154936, 154935, 154940.

Then you can put the following command somewhere:

=query(A:B, "select * where A matches '" & join("|", C1:E1) & "'")

This does the following:

  1. Joins the row of numbers to filter by, using | as a separator.
  2. Uses this string 154936|154935|154940 as a regular expression in the where ... matches selector.
  3. Selects all columns (within the specified range, A:B) from the rows that matched.
  • Hi, thanks for the reply. I am sorry I confused the question with the word row (I edited it now) but all the data is in one column only. I have all orders in one column and the next day status changes like some orders get shipped, some delivered, some returned. I want to update this status by filter. – Ted Nov 11 '15 at 6:28

Not the answer you're looking for? Browse other questions tagged or ask your own question.