Applying filter based on numbers inside a sentence. Google Sheet

Google Sheet

I have a list that i want to filter based on the numbers in a sentence.

Example Sentence:

Show me the data of number :3,6


So the filtered data should show 3 and 6 only. Additionally just get the first sentence in of the rows being asked.

Thanks.

Sample attachment

Vlady - as a Moderator, you ought to know that GoogleSheets queries should be posted in the Other Platforms section. Once again, I have moved your thread.

Sorry Aligw.

Thanks windknife

@vlady;

This is my alternative, where the requested items (3 and 6 in your example) are picked from the sentence in cell C5.

You can have as much as you want, such as it may be; "Please give me the data of 3,6,4,7"

items in the sentence must be seperated with a comma as seen above.

The formula in cell C6 and screen shot is given below;

Please Login or Register  to view this content.

****************************************

If you need only the first sentences without the question numbers at the beginning, you can use this;

Please Login or Register  to view this content.

The screen shot for the first formula is;