Longshot

[stewie1234]

I have to go through 14000 rows of data and validate them with another sheet but the problem is I have to change the original to match the other sheet but there are rows in one sheet that aren't in another I have to put on another tab and vice versa. Any ideas besides going through them one by one?? I also have to highlight all the changes. Thanks for any input!

 

[steve the fish]

Id use concatenate and then countifs to see which rows were identical from one sheet to another.

 

[stewie1234]

Id use concatenate and then countifs to see which rows were identical from one sheet to another.

Could you give me an example please?

 

[steve the fish]

Concatenate every column that you have in each worksheet. If you have two columns for example the formula to place in each sheet cell C1 is =A1&B1 then in D1 =COUNTIF(Sheet1!C:C,C1). If the identical data appears in each sheet then the countif returns 1 (or more if it appears more than once). If the line doesn't appear in the other sheet it will return 0.