CODEWITHSUNDEEP
excelcompare
Grizzly
Grizzly

Reputation: 5943

Compare 2 excel sheets based on 1 column

If I have 2 sheets in Excel that look like this:

Sheet 1:

|    IBM    |    First Name    |    Last Name    |
--------------------------------------------------
     1542          John                 Doe
     1487          Blah                 Blah

Sheet 2:

|    IBM    |    First Name    |    Last Name    |
--------------------------------------------------
     1542          John                 Doe
     1487          Blah                 Blah
     1849          Third                Name

Now, I need the outcome to provide me the people that exist in sheet 2 but do not exist in sheet 1, based on IBM.

So in this particular example, I need the outcome to be:

IBM: 1849

Can this be done in excel? If so, how?

Upvotes: 0

Views: 65

Answers (1)

VBA Pete
VBA Pete

Reputation: 2666

The COUNTIF function is an easy way to check if a value exists in a data set:

=COUNTIF(Sheet1!A:A,A1)

enter image description here

Upvotes: 2

Related Questions