Distinguish 1 from 14 when using the filter

[Ken64]

Good afternoon All,
If this is a duplicate, I am sorry. I did not see my original posted. I have multiple numbers in cells A1,A2,A3... How do I use the filter and type in 1 in the search window and only have it show those rows with contain 1 and not 14?

Thank you,
Ken

[AlKey]

Right-click on any cell that has value of one and select from the menue Filter by cell's value

[Ken64]

Thank you for the response, however it does not work or I am doing something wrong.
I am using, from the ribbon, the Editing/filter option on multiple columns in my table. Cell H1 is the header with the word Options. The cells below contain multiple number...H2 = 1,2,3,4 H3 = 3,6,11 H4 = 4,5,6,22 H5 = 1,5,31. Now when I click the filter button within the cell and type 1 to show only parts used for Option 1, it shows row 2,3, and 5, when I only want it to show 2 and 5 as they are contain "1". I got around this by changing the numbers to the alphabetical equivalent, but was wondering if there was another way, like type in a special character.

Thank you,
Ken

[AlKey]

Please see the spreadsheet with a screenshot.

[Xx7]

--- removed: different thread reply

[Ken64]

Here is a down and dirty shot of what I am working with.sample.xls

[AlKey]

This is different! LOL. I din't expect there would be concatenated values in the cell. The good thing is that if there is 1, it would be the firs in the cell and as the values are sorted in ascending order. So if you need to filter cells that contain 1, use this formula in cell D2 and copy it down. It will give you TRUE/FALSE then you can filter by TRUE.

=LEFT(A2)="1"

[Ken64]

Thank you for the response. However searching for 1 was an example. I may need to search for 2,3,4 and so on and if I need to filter by "3' and the H1 contains 1,2,3 and H2 contains 2, 4, 6,13 and H3 contains 1,2,3,7,9 then the left function will not work. I was hoping instead of typing 3 in the search window of the filter there was a special character or way of entering it. Even if I change the numbers from 1,2,3...to one, two, three and so on the filter will still show the cells with twentyone. I changed the numbers to letters and it worked since there are less than 26 numbers. Thank you for the suggestions.

[AlKey]

Please see attached file. By changing value in D1 you can search by any number.