+ Reply to Thread
Results 1 to 2 of 2

Sorting Specific Character String in Column

  1. #1
    Registered User
    Join Date
    08-16-2010
    Location
    Mt. Vernon, IN
    MS-Off Ver
    Excel 2003
    Posts
    1

    Sorting Specific Character String in Column

    I'm going through manufacturing data and need help capturing specific data.

    1 column has information on the type of product manufactured, e.g. COY-213-BT, or LL-221-SS.

    There are ~9000 entries (rows), with about 20 columns of data. I am only concerned with sorting by the 'type of product' column and the 'material type'.

    I just want to capture all the rows (the entire row, not just the 2 data points in the 2 columns I'm sorting by).

    I need to capture all product types that have 'BT' at the end of the string of characters. Thankfully 'BT' will not appear anywhere but the end, so the macro does not need to specifically look after the 2nd hyphen. Out of these entries, I only need to capture times with "Pellet" in the 'material type' column.

    If sorting it twice makes it overly complicated, the major issue is capturing product types with BT in the character string.

    I have no macro experience, FYI.

    Thanks!

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Sorting Specific Character String in Column

    You should find you can apply an Auto Filter to the Range and specify some text based criteria to the columns you mention - if you're happy with the output Record yourself applying the process from start to finish.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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