Results 1 to 13 of 13

Using a formula to compare and highlight differences between two columns of ID numbers

Threaded View

  1. 12-22-2017, 03:36 PM #1
    Anthony2017
    Anthony2017 is offline
    Registered User
    Join Date
    01-24-2017
    Location
    Ireland
    MS-Off Ver
    2007
    Posts
    15

    Using a formula to compare and highlight differences between two columns of ID numbers

    Hi I have two columns of ID numbers on a spread sheet, column 1 has ID numbers that have been imputed into and stored with in an ERP management system, column 2 are all the ID number from the customer.

    What I want to do is compare the customer column to the ID numbers in the system so I know what has not been imputed.

    Iv tried Vlookup and match but cant get it to work.

    Attached is an example of the numbers in the columns.

    The actual spread sheets have around 100 + ID numbers.

    Any help would be appreciated.
    Attached Files Attached Files
    Last edited by Anthony2017; 12-22-2017 at 04:00 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare two lists each with two columns, highlight differences. CAD vs ERP BOM compare.
    By daniellowery6 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-27-2016, 05:56 PM
  2. [SOLVED] Compare Columns In Different Workbooks and Highlight Differences
    By sunirone in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2016, 07:54 PM
  3. [SOLVED] Formula to compare 2 columns for differences
    By Chris McGlothen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2016, 01:41 PM
  4. Compare 2 columns and highlight differences
    By zookeepertx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2014, 01:41 PM
  5. Compare multiple columns from 2 spreadsheets, highlight differences & return values
    By excellerant8 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-17-2014, 10:06 AM
  6. Need Macro to Compare Two Sheets with Same Columns Highlight Differences using Unique ID
    By Sissygirl in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-18-2013, 03:54 PM
  7. [SOLVED] Compare columns in different worksheets nad highlight differences
    By intercooler in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-13-2012, 01: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1