# Software

## General discussion

Locked

### Comparing 2 Columns in Excel

By ·
I have two rather extensive columns that I need to compare. The list of numbers are different in each column (even by 10 or 15 numbers). I need to compare both columns and have the results of the differences show up in another column. Do I use Vlookup or Advanced Filter? If yes, to either question, which one is easier and how do I get the desired results.

Thank you, I am eternally grateful.

Mary.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

Collapse -

### Comparing 2 Columns in Excel

by In reply to Comparing 2 Columns in Ex ...

Please define compare. If your just trying to find the difference you can use a simple formula. If your trying to find duplicates, the problem is approached in a different manner. Are you looking for an answer for each record or a total for all records? Are you looking for sub totals?

Collapse -

### Comparing 2 Columns in Excel

by In reply to Comparing 2 Columns in Ex ...

Column 1 and 2 have different numbers -- I need a list of all the numbers that are not included from Column 1 in Column 2.

Collapse -

### Comparing 2 Columns in Excel

by In reply to Comparing 2 Columns in Ex ...

well, i haven't had my coffee yet so don't shoot me, but why not, if numbers, subtract one column from another (put the formula that does it in the 3rd column...)anything non-zero is not identical...?

Collapse -

### Comparing 2 Columns in Excel

by In reply to Comparing 2 Columns in Ex ...

Collapse -

### Comparing 2 Columns in Excel

by In reply to Comparing 2 Columns in Ex ...

That's probably the method I would use.

Collapse -

### Comparing 2 Columns in Excel

by In reply to Comparing 2 Columns in Ex ...

Collapse -

### Comparing 2 Columns in Excel

by In reply to Comparing 2 Columns in Ex ...

Column 1 has a series of numbers (maybe 1000) and I would like to see what numbers have been excluded or included from Column 2 (which may have 1100 numbers). What is the best approach?

Collapse -

### Comparing 2 Columns in Excel

by In reply to Comparing 2 Columns in Ex ...

This question was closed by the author

## Related Discussions

• 3

#### Neat scanner NWDB files, how can you access the images?

joseppiedotcom99 ·

• 4

#### Quickbooks 2017 crash com Error

AcerNancy98 ·

• 1

#### php related validation issue

himanitechbag ·

• 2

WernDB ·

• 1

#### Which is Best Software for Gym Fitness Club Business Management?

nomedamilton ·