Compare columns

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have two columns of IDs. Column A is the bigger of the two. Column B has IDs that are part of Column A. How to produce all IDs that are not in Column B but in Column A and get the results in another column?

Thanks!

3 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
Thank you for the quick reply. Could not access above mentioned sites in my office so I will recreate my problem here.

UserIDA UserIDB Desired Results
AAR9648 AAR9648 ADA5335
ADA5235 ALE2655 ALV1462
ALE2655 BAS7448 BER8149
ALV1462
BAS7448
BER8149


Column B is a subset of Column A. I want Column C to show all values that are in A but not in Column B.

I am a beginner in Excel and would very much appreciate some step by step help.

Thanks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Are you just trying to see which value is there and which is not

Since you said that you are new to excel, would it not easy to use formula

in C2 you can have

=IF(ISERROR(MATCH(A2:B:B,0)), A2, "")

and drag it to the last row of column A

This basically will show you where the value in column A does not match column B

You can apply filter for blank to see where they match and non-blanks to see where it matches. If you still want to go to macro, let me know