Compare columns

Closed
divya - Jun 21, 2010 at 12:28 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 22, 2010 at 04:26 PM
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

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 21, 2010 at 06:02 PM
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
0
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
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 22, 2010 at 04:26 PM
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
0