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
767
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 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!