Filter rows by a set of numbers from another column [closed]

Question

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

orderid
154934
154935
154936
154937
154938
154939
154940

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.

Answer 1

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.