Previous Topic Next Topic

Comparing rows of data

Closed
Steveinuk - Feb 2, 2011 at 08:40 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 05:23 PM
Hello,

I am trying to compare two sheets of data, column A has the company common key code to compare.

Sheet1
ColA - Company Code: 1234
ColB - NameofCo: ACME Corp.
ColC - Price: 321.01
ColD - Code: XYZ
ColE - Country: US

Sheet2
ColA - Company Code: 1234
ColB - NameofCo: ACME Corp.
ColC - Price: 321.01
ColD - Code: XXX
ColE - Country: US



Note that the matching Company code may not be on the same row. There are many rows of Company codes.

I need to check the rows on the sheets where the company code matches, and then check if any of the additional columns (B-E) do not match. If a mismatch is found (I.e. Col.D in example) it needs to add that entire row from sheet 2 to new sheet3.

Thanks
Steve

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 9, 2011 at 05:23 PM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting 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.


Note: your data need not be to be real data but a good representative of how data looks like
0