Re: Can I filter cell that have only 0-9 number in it?

Discussion in 'Microsoft Excel New Users' started by Claus Busch, Jul 13, 2012.

  1. Claus Busch

    Claus Busch Guest

    Hi,

    Am Fri, 13 Jul 2012 03:48:45 +0000 schrieb lazyx:

    > samsung
    > samsung galaxy s2
    > samsung galaxy
    > samsung galaxy tab
    > samsung galaxy nexus
    > samsung galaxy note
    > samsung infuse
    > samsung galaxy tab 10.1
    > samsung tv
    > samsung galaxy s3
    > samsung galaxy s
    >
    > I want to filter cells that have any number in it (0-9). So, the end
    > result should shows only :


    your products in column A from A2 on. Then make a helper column with the
    formula:
    =COUNT(FIND({1;2;3;4;5;6;7;8;9;0},A2))>0
    and filter the helper column for TRUE


    Regards
    Claus Busch
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Jul 13, 2012
    #1
    1. Advertisements

  2. Claus Busch

    Claus Busch Guest

    Hi,

    Am Fri, 13 Jul 2012 10:03:17 +0200 schrieb Claus Busch:

    > your products in column A from A2 on. Then make a helper column with the
    > formula:
    > =COUNT(FIND({1;2;3;4;5;6;7;8;9;0},A2))>0


    change the formula to:
    =COUNT(FIND({1,2,3,4,5,6,7,8,9,0},A2))>0


    Regards
    Claus Busch
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Jul 13, 2012
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    AUTO FILTER OR ADVANCED FILTER

    Guest, Mar 6, 2004, in forum: Microsoft Excel New Users
    Replies:
    6
    Views:
    926
    Guest
    Mar 6, 2004
  2. Bob Umlas

    Re: Filter - Advanced Filter?

    Bob Umlas, Aug 13, 2004, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    172
    Bob Umlas
    Aug 13, 2004
  3. Guest

    adding number only if CDN is displayed in next cell

    Guest, Dec 21, 2005, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    187
  4. Ping

    How can I only the cells showing by a filter?

    Ping, Dec 19, 2007, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    188
    Gord Dibben
    Dec 19, 2007
  5. Walter

    replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER

    Walter, Feb 23, 2008, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    299
    Walter
    Feb 24, 2008
Loading...

Share This Page