Compare numbers in two columns in Excel

Solved/Closed
rypton - Mar 26, 2010 at 09:45 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - 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.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 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
2