Results 1 to 7 of 7

How to Return Differences between Two Columns?

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2021
    Location
    US
    MS-Off Ver
    Mac Version 16.58
    Posts
    21

    How to Return Differences between Two Columns?

    Hello,

    What I'm trying to do is to return differences between two IDs. In the file, column A contains new IDs, and column B contains names associated with it. There's also a column with Old IDs.
    I need:
    1. to pull IDs from column A that aren't in an old column (pull the differences)
    2. to pull list of names from column B that will correspond to the IDs from column A

    I hope someone can help here. I tried different formulas, and conditional formatting, but for some reason it doesn't pull all the different IDs.

    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. Compare strings and return differences in Excel
    By dfghjk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2020, 02:43 PM
  2. Replies: 9
    Last Post: 01-13-2020, 10:16 AM
  3. VBA script to compare two workbooks and return differences between the two?
    By pizzaguy4487 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2018, 12:31 AM
  4. Compare two columns and return differences
    By twachtmann56 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-07-2016, 08:10 PM
  5. [SOLVED] Compare data in Columns A & B - Show differences in Columns C & D
    By syncguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2015, 09:59 PM
  6. Replies: 0
    Last Post: 07-17-2014, 10:06 AM
  7. Compare Worksheets and Return Differences
    By bkeller83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-16-2009, 01:52 AM

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