Find non Duplicate records in EXCEL

Search Close

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

All fields are required. Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

Question

Creator

Topic
August 2, 2007 at 8:13 am #2224807

Find non Duplicate records in EXCEL

Locked

by cavazos212 · about 15 years, 4 months ago

Hello, I’m trying to search two tables that have about 12989 records on them and that are supposed to have the same data on each other, but what seams to happen is that some people only update one table and not the other. I have entered both tables into individual column in excel column A and column B I have tried conditional formatting, but it only highlights the data that is not in the other side, but I still have to search through it and pull out the non duplicates is there a way to compare these two columns and have the data inserted into it’s own column?

The data that I am comparing is alphanumeric and looks like this (ABCC CS 4698 T/C)

This conversation is currently closed to new comments.
Creator

Topic

All Answers

Author

Replies
- August 2, 2007 at 8:13 am #2634835
  
  Clarifications
  
  by cavazos212 · about 15 years, 4 months ago
  
  In reply to Find non Duplicate records in EXCEL
  
  Clarifications
- December 9, 2009 at 9:09 am #2836270
  
  Use a VLOOKUP
  
  by bigdave327 · about 12 years, 11 months ago
  
  In reply to Find non Duplicate records in EXCEL
  
  You can create a list of values that match columns A&B in Column C with a vlookup: =VLOOKUP(B1,A$1:A$12989,1,FALSE). You’ll need to sort column A from A to Z (you don’t need to sort Column B, but you may want to so that you can see how the two columns line up). VLOOKUP will take the value in Column B and return the matching value in Column B. When no match is found you’ll get #N/A.
Author

Replies

Viewing 1 reply thread

Start or Search

Start New Discussion

Password-driven security may not be the perfect solution, but the alternatives haven’t gained much traction. This policy defines best practices that will make password protection as strong and manageable as possible. From the policy: Employee passwords are the first line of defense in securing the organization from inappropriate or malicious access to data and services. ...

Recruiting candidates with advanced software engineering experience and a least some familiarity with applied blockchain technology will take time and effort. This hiring kit provides a workable framework you can use to find, recruit, and ultimately hire the best candidate for Blockchain Engineer in your organization. From the Hiring kit INTRODUCTION Moving well-beyond its cryptocurrency ...

This policy provides guidelines for secure and effective cloud computing operations to ensure the integrity and privacy of company-owned information. From the policy: The list of advantages to cloud computing includes lowered operational costs, greater technological flexibility, and the ability to rapidly implement new systems or services. Gains in business continuity are an especially noteworthy ...

Due to scheduled maintenance, the ability to log in to your account and make purchases will be disabled December 1 - 2.

Software

Question

Find non Duplicate records in EXCEL

All Answers

Clarifications

Use a VLOOKUP

Password management policy

Hiring kit: Blockchain Engineer

Cloud computing policy

Payroll services comparison tool