+ Reply to Thread
Results 1 to 1 of 1

How to find common string column from two columns??

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    United Arab Emirates
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post How to find common string column from two columns??

    2 Columns of data will be provided ( Option String 1 & Option String 2 ).
    On the click of the "Run" button ( button to be created ), a MACRO will create the 3rd column of Common string.
    The cells under the Common String column must contain the common codes ( eg, CF5, CW2 etc.... ) from the first 2 columns and must be separated by comma in alphabetical order.



    Option String 1
    27I,CF5,CW2,L98,M32,PDP,U32,UV9
    27I,CF5,CW2,L98,M32,PDP,UV9
    51I,CF5,CW2,L98,M32,PDP,U32,UV9
    51I,CF5,CW2,L98,M32,PDP,UV9
    27I,CF5,CW2,L98,M32,PDP,U32
    27I,CF5,CW2,L98,M32,PDP

    Option String 2
    CF5,CW2,L98,PPO
    L98,M32,PDP,APO
    L98,M32,PDP,XCU
    CF5,CW2,L98,M32
    L98,M32,PDP,RTY
    CF5,CW2,L98,M32


    ***VERY URGENT SOMEBODY HELP ME***
    Last edited by sanil.henry1982; 12-15-2012 at 08:14 AM. Reason: Very Urgent

+ 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