+ Reply to Thread
Results 1 to 2 of 2

Compare to strings for a match (string data may not be in same order)

  1. #1
    Forum Contributor
    Join Date
    09-05-2011
    Location
    Essex, England
    MS-Off Ver
    Excel 2003 Excel 2007
    Posts
    383

    Compare to strings for a match (string data may not be in same order)

    Hi There,

    I have two arrays; vPLAN (with elements "DAY", "REGION", "CUSTOMER INITIALS" as a string, "AM/PM") and vSCHEDULED (with elements "DAY", "STAFF INITIALS", ""CUSTOMER INITIALS" as a string, "AM/PM").

    what I would like to do is for each day and each Time Zone (am or pm) is compare the CUSTOMER INITIALS strings to of each array to ensure they match and if not generate a new entry in a new array vERRORS with the "STAFF INITIALS", "DAY", "EXPECTED" (string from from vPLAN). "ACTUAL" (String from SCHEDULE).

    I can generate the new array easy enough once I have the data. the issue I have is that i'm not sure how to ensure that when checking the two strings that "A B C" is shown as matching "B C A"

    thank you for any help with this.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Compare to strings for a match (string data may not be in same order)

    Can you provide a sample workbook with sample input and desired output?
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Replies: 4
    Last Post: 05-30-2015, 11:45 AM
  2. [SOLVED] Compare strings for match in separate worksheet and return nearest future date
    By kungfood in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2012, 05:19 PM
  3. [SOLVED] loop to match if shorter strings appears in longer strings
    By mcdermott2 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2012, 08:07 PM
  4. Replies: 2
    Last Post: 10-23-2010, 04:54 PM
  5. Compare a string in two columns, if match then append string from third column
    By Londonderry in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2007, 03:41 PM
  6. Compare data strings?
    By Ed in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2005, 09:40 AM
  7. Compare strings of data
    By Hal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-28-2005, 12:05 PM

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