Results 1 to 3 of 3

find mismatch in 2 columns

Threaded View

murthigvs find mismatch in 2 columns 08-09-2017, 05:19 AM
thatandyward Re: find mismatch in 2 columns 08-09-2017, 08:46 AM
murthigvs Re: find mismatch in 2 columns 08-11-2017, 06:58 PM
  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    sheffield, england
    MS-Off Ver
    Excel 2010
    Posts
    38

    find mismatch in 2 columns

    dear friends,
    in the attached xls, col 1 and 2 are the master code and description respectively. in cols 3 & 4, i have my list of codes and description. however, i think that in col 3 and 4, some of the codes do not match the description (as compared to the master). i would like a solution that identifies the rows where the code and description in col 3 and col 4 do not match the master. thanks for your help.

    yours sincerely
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to find the +/- net to 0 and copy combination move to corresponding mismatch list
    By julielara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2016, 03:32 PM
  2. Finding Possible Mismatch between columns
    By ankituc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-16-2015, 09:11 PM
  3. Type13 Mismatch on Find/offset
    By SamuelJackson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2014, 06:10 PM
  4. Type Mismatch on find command
    By Abbadon486 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2014, 06:51 AM
  5. [SOLVED] Can't find type mismatch
    By captive in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2013, 11:56 AM
  6. MisMatch Error for the Find Method
    By Schopf86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2011, 01:31 PM
  7. Type Mismatch Error on Find Closest Match
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2007, 11:07 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