Hey,

So there is probably another way i will have to do this but, i have a list of letters and number and i use the search > contains feature to grab the majority of information e.g.
2c2d
2c2s
2d2s
3c2c
3d2d
3s2s
4c2c
4d2d
4s2s
5c2c
5d2d
5s2s
6c2c
6d2d
6s2s
7c2c
7d2d
7s2s
9c2c

I would type contains 5 and it would come back with 5c2c,5d2d,5s2s but i want to be able to grab all the cells that have the same recurring number i.e 2h2h, 3s3h, 5h5c
I know i can use the "?" so that it ignores the letters but what would i use to make the numbers = eachother. X?X? is the kind of thing i thought it would be. I am guessing this might not be able to be done in the search > contains feature?