Posts by KNZ

    Hi trunten
    I tried custom filter, equals 1 OR contains 1,
    It seems to be missing some rows. Also critea allowed is only two.
    Would have liked criteria equals = 1 OR contains 1, OR ,1,
    This way it would pick cell with number 1 only, cell which being with 1, and cell which has with ,1
    (Please note the commas - after 1 and before 1)
    Any help appreciated

    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"]

    [tr]


    [td][/td]


    [td]

    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