Compare columns
Closed
divya
-
Jun 21, 2010 at 12:28 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 22, 2010 at 04:26 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 22, 2010 at 04:26 PM
Related:
- Compare columns
- Beyond compare - Download - File management
- Display two columns in data validation list but return only one - Guide
- Excel compare two columns for partial matches - Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
- How to compare two Excel sheets with varying data ✓ - Excel Forum
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 21, 2010 at 06:02 PM
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
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
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 22, 2010 at 04:26 PM
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
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
