Results 1 to 3 of 3

Excel compare 2 columns/lists for differences or unique values

Threaded View

  1. #1
    Registered User
    Join Date
    07-08-2017
    Location
    Minnesota
    MS-Off Ver
    Microsoft Office 2016
    Posts
    78

    Excel compare 2 columns/lists for differences or unique values

    Hello,

    In the attached spreadsheet, column A will be the prior month data always being dropped in as paste values. I will then drop the current month (new) data into column C. There will be more lines in column C every time for numbers that were added. I am looking for a formula so that I can do a conditional formatting to highlight and easily identify quickly what numbers are new and not in column A. Can someone please help?


    Thanks!
    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. Replies: 2
    Last Post: 11-27-2016, 05:56 PM
  2. Replies: 0
    Last Post: 07-17-2014, 10:06 AM
  3. Excel 2010 Formula - compare lists to determine differences
    By t.regi in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-19-2013, 11:51 PM
  4. [SOLVED] Compare two lists and copy unique values to the second list
    By Brumbot in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-06-2013, 07:36 AM
  5. Replies: 9
    Last Post: 04-18-2013, 03:54 PM
  6. Compare two lists and highlight the differences
    By jsmo in forum Excel General
    Replies: 3
    Last Post: 08-28-2012, 10:27 PM
  7. Compare two lists and highlight differences.
    By delgadotb in forum Excel General
    Replies: 1
    Last Post: 03-30-2009, 03:24 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