Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using Autofilter (Excel 2000)

    I have a table with the following fields in a column

    A1 M05 T0 Rebates
    A1 M05 T1 Rebates
    A1 M05 T2 Rebates
    A1 M05 T3 Rebates
    A1 M05 Rebates
    A1 M05 Advertising

    Is it Possible to filter on the field to exclude T0,T1,T2,T3

    Thanks for the help/ideas

    Mario

  2. #2
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Using Autofilter (Excel 2000)

    You could make a copy of your data keeping the duplicate data in the same rows. Then, use Data | Text to Columns to parse the data and autofilter (Blanks) the parsed data. This will hide the rows in the original column. See attached sheet. HTH --Sam
    Attached Files Attached Files
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Using Autofilter (Excel 2000)

    The Autofilter takes wildcards so you could use <pre> does not begin with ?? ??? T</pre>

    However that would that any record with a T in that postion would be exluded.

    Andrew C
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •