Compare numbers in two columns in Excel [Solved/Closed]

Question

Compare numbers in two columns in Excel [Solved/Closed]

Report

rypton - Mar 26, 2010 at 09:45 AM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- Mar 26, 2010 at 10:51 AM

I appreciate any response to help me with this.

I have two columns of numbers
A B
B.121 S.222
S.154 B.121
B.164 S.154
B.187 B.154

I have about 100 lines of this data on multiple tabs (roughly 1000 or so in total)
Both columns have essentially the same numbers but column B has multiple instances of the same number. Column A is unique

I need to ascertain if every number in Column A is present in Column B at least once
and i need to know the number that's missing from column B.

Thanks a lot.

Compare numbers in two columns in Excel
How to compare names in two columns in excel ✓ - Forum - Excel
Compare two columns in excel for partial matches - How-To - Excel
Excel - Comparing cells across multiple columns - How-To - Excel
How To Compare Two Columns in Excel - How-To - Excel
Excel - Compare data from two columns - How-To - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2010-03-26T10:51:38-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767
Mar 26, 2010 at 10:51 AM

well you can add in column C countif formula. Presuming your data starts at row 2

In C2 you can write

=COUNTIF(B:B,A2)

It will tell you how many time the value A2 appeared in column B
You can drag this formula down to the last data row

Compare numbers in two columns in Excel [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!