+ Reply to Thread
Results 1 to 3 of 3

Help with Filtering Key words/Letters in Columns

  1. #1
    Registered User
    Join Date
    10-27-2015
    Location
    CT, USA
    MS-Off Ver
    2010
    Posts
    36

    Help with Filtering Key words/Letters in Columns

    I have been trying to find a way to Filter two Columns. First by filtering the "Part number" so that they are grouped, which I believe I have done in VBA.
    From there I want to filter the "Status" column by removing anything with an "F", then deleting that row.
    Next remove anything else that does not contain "Pass", "P_TC" and "PTC". These guys are keepers. All that should be left when filtering the "Status" column is "Pass", "P_TC" and "PTC".

    Just cant seem to filter the "Status" Column like I did with the "Part Number" column...

    Im thinking of just deleting everything that does not contain the key words first, then filter the "Part Number Column".

    So... In Summary, Just really need to Filter the crap out of the "Status" Column and delete said crap.




    Any help in the right direction will be valued.
    Thank you in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Help with Filtering Key words/Letters in Columns

    Try this.

    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Registered User
    Join Date
    10-27-2015
    Location
    CT, USA
    MS-Off Ver
    2010
    Posts
    36

    Re: Help with Filtering Key words/Letters in Columns

    Thank You skywriter! Just what i was looking for! It worked like a charm.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. COMBINE LETTERS into WORDS
    By JPSQ in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-24-2022, 07:52 PM
  2. Sort combination of words and letters
    By emielbrak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2015, 06:55 AM
  3. Count letters/words
    By PhilS5 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-03-2014, 05:06 PM
  4. Removing words under 4 letters
    By jeremyh09 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-30-2013, 12:23 AM
  5. Sort and total letters in different words
    By rama_chandran in forum Excel General
    Replies: 1
    Last Post: 08-19-2013, 04:34 PM
  6. [SOLVED] total value of letters from words in cells
    By teacher2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2013, 01:32 PM
  7. Need to scramble letters in list of words
    By SusanB in forum Excel General
    Replies: 1
    Last Post: 03-28-2006, 12:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1