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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    AUTO FILTER OR ADVANCED FILTER

    Guest, Mar 6, 2004, in forum: Microsoft Excel New Users
    Replies:
    6
    Views:
    1,124
    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:
    330
    Bob Umlas
    Aug 13, 2004
  3. Replies:
    2
    Views:
    531
  4. Bob

    Need to have cell fill when cell is selected

    Bob, Apr 27, 2005, in forum: Microsoft Excel New Users
    Replies:
    1
    Views:
    247
    Otto Moehrbach
    Apr 27, 2005
  5. Guest

    adding number only if CDN is displayed in next cell

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

    How can I only the cells showing by a filter?

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

    replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER

    Walter, Feb 23, 2008, in forum: Microsoft Excel New Users
    Replies:
    3
    Views:
    556
    Walter
    Feb 24, 2008
  8. TIJ

    Data>Filter>Auto Filter in excel 2007?

    TIJ, Nov 12, 2008, in forum: Microsoft Excel New Users
    Replies:
    2
    Views:
    1,294
    Shane Devenshire
    Nov 13, 2008
Loading...