+ Reply to Thread
Results 1 to 1 of 1

Compare & ENTER the Mismatched characters in the third column with 1 condition

  1. #1
    Registered User
    Join Date
    12-04-2014
    Location
    Chennai
    MS-Off Ver
    2013
    Posts
    19

    Question Compare & ENTER the Mismatched characters in the third column with 1 condition

    Need to compare the vendor a output in a column with vendor b in b column & enter the mismatched characters in c column

    compare vendor a output - a column
    compare vendor b output - b column

    enter mismatched characters / "spacing error" in c column

    1 scenario:
    A - 6 7 a5 6 752 26 7 1 6352 6 7 173 6 71
    b - 6 7 a5 6 752 26 7 1 6352 6 7 173 6 71
    c - spacing error

    2 scenario:
    A - 2 6 7 15 6 752 26 7 1 6352 6 7 173 v 71
    b - 2 6 7 05 6 75 2 26 7 1 6352 6 7 173 v 71
    c - 2, spacing error

    3 scenario:
    A - 6 7 15 6 152 26 7 1 6352 6 7 173 6 71
    b - 6 7 15 6 152 26 7 1 6350 6 7 173 6 71
    c - 0

    4 scenario
    a - 6 7 15 6 752 26 7 1 635u 6 7 173 6 71
    b - 6 7 15 6 752 26 7 1 635v 6 7 173 6 71
    c - v

    attached the sample file for clear understanding.
    Attached Files Attached Files
    Last edited by Sivashanmugam; 04-21-2015 at 03:37 AM.

+ 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. compare 2 columns if same lookup 3rd column and enter that data
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2014, 10:28 AM
  2. [SOLVED] Find Mismatched Cell Values
    By RedMug in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-18-2014, 12:55 AM
  3. using rows of mismatched values across sheets
    By jslesser in forum Excel General
    Replies: 9
    Last Post: 11-27-2011, 03:50 PM
  4. [SOLVED] Compare 2 columns and choose one and enter answer in third column
    By Betsy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-30-2006, 01:20 PM
  5. Compare List and Show Mismatched
    By Phillycheese5 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-22-2005, 12:25 PM

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