+ Reply to Thread
Results 1 to 5 of 5

Sort Column data based on another columns content

  1. #1
    Registered User
    Join Date
    11-29-2018
    Location
    Ireland
    MS-Off Ver
    Excellent for Mac Version 14.7.3
    Posts
    2

    Question Sort Column data based on another columns content

    15429680248902637.png


    In the Above worksheet I have two columns, Column A Data has a matching row that contains the text in Column B eg. 2017_PS_DE_Epay_gCard_WEWCY_VD_BAR.eps from Column A and WEWCY from Column B

    I am looking to re sort Column A into a new column so the rows match the corresponding Data in Column B

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: Sort Column data based on another columns content

    One way is to PARSE the data in column A. I would copy column A to another worksheet, then select all the cells in column A; On the ribbon DATA; then TEXT TO COLUMNS; Delimited ( and put the underscore character in the 'OTHER' box; then finish. [ this will isolate the items to match up with column B.] you can then use vLookup to match up the columns.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Sort Column data based on another columns content

    In C1 put
    =VLOOKUP("*"&B1&"*",A$1:A$33,1,0)
    change the 33 to your last row of data & filldown

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Sort Column data based on another columns content

    this might work for you to simply "pull" out those sections. =MID(A2,23,5)
    it appears to work based on the hand entered sample I tried, then you don't have to deal with that column.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Registered User
    Join Date
    11-29-2018
    Location
    Ireland
    MS-Off Ver
    Excellent for Mac Version 14.7.3
    Posts
    2

    Re: Sort Column data based on another columns content

    That has worked a treat, Thank you

+ 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. [SOLVED] Sort by specific column & delete rows based on content
    By axtryo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-21-2018, 01:49 AM
  2. [SOLVED] Sort columns B,C,D based on column B then loop to next 3 columns and repeat till last colu
    By Andy15 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-09-2017, 05:35 PM
  3. [SOLVED] Build Column D based on Columns A, B, and C (which have varying size and content)
    By amanzi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-18-2016, 11:43 AM
  4. [SOLVED] sort columns based on another column
    By kuntalnr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2015, 06:41 PM
  5. Replies: 5
    Last Post: 10-26-2011, 11:57 AM
  6. Replies: 5
    Last Post: 10-01-2010, 05:00 AM

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