In my Column D i have numbers. Normally most of the rows for Col D will have single number eg 2 or 12 or 22 and so on. However on some occasion it will have two or more numbers eg 2, 4,12. The numbers in the cell are separated by commas.
Example
[TABLE="border: 1, cellpadding: 1"]
ColD
[/td][/tr][tr][td]Row1
[/td][td]1
[/td][/tr][tr][td]Row2
[/td][td]4
[/td][/tr][tr][td]Row3
[/td][td]2,12
[/td][/tr][tr][td]Row4
[/td][td]11,1
[/td][/tr][tr][td]Row5
[/td][td]2,1
[/td][/tr][tr][td]Row6
[/td][td]3
[/td][/tr][tr][td]Row7
[/td][td]21
[/td][/tr][tr][td]Row8
[/td][td]1,11,15
[/td][/tr][tr][td]Row9
[/td][td]10,1,9
[/td][/tr][tr][td]Row10
[/td][td]1,16
[/td][/tr]
[/TABLE]
How can I select
all the rows that has in Col D the number 1
ie in the above example it would select row1,row4,row5,row8,row9 and row10
Many thks
KNz