+ Reply to Thread
Results 1 to 3 of 3

Macro to match values in cells separated by semicolon and comma

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    Phila
    MS-Off Ver
    Excel for Mac 2011
    Posts
    25

    Macro to match values in cells separated by semicolon and comma

    Dear All,

    My excel sheet contains 6 columns with information that is related to each other. In 3 of the columns (D-F) there are multiple entries, most of the time separated either by "%7C" and/or by a "comma". The data on column F is organized in a way that relates to how information is given (organized) in columns D and E. I need to match the score information on column F with correspondent experiment and sample information on columns D and E, respectively. I am new at dealing with macros and was wondering if it is even possible to write a macro able to do this. I have created a sample file with more detailed information about the way data is organized and how I would likely want the data to be organized after applying the macro. I would enormously appreciate your help in this since the real file I have to deal with contains about 60000 rows and is unlikely that I can organize all the data just by hand.

    Thank you for your time,

    Ale84

    Example for excel forum help.xlsx

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Macro to match values in cells separated by semicolon and comma

    Hi

    This was written for a dos machine, not a mac, but hopefully it will translate.

    Make sure that you have a blank output sheet called sheet2 in your workbook.

    Use the example file, and remove everything in Sheet1 below row 14, so you are only left with the data in the range A1:F13 (leave the "data before macro in row 1).

    Then try

    Please Login or Register  to view this content.
    It doesn't have any formatting or merged cells. I'm just trying to get the data correctly separated.

    rylo

  3. #3
    Registered User
    Join Date
    02-13-2013
    Location
    Phila
    MS-Off Ver
    Excel for Mac 2011
    Posts
    25

    Re: Macro to match values in cells separated by semicolon and comma

    Amazing Rylo, thanks!

+ 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