Compare numbers in two columns in Excel

Solved/Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month