Forum Discussion

jjesposito's avatar
jjesposito
Copper Contributor
Aug 04, 2020
Solved

Excel 2007 comparing sheets

On Excel 2007, I need to compare two sheets. 

Is it possible to identify consistent data within sheet one and sheet two automatically? 

For example, 

Sheet one, column A, row 2: ABC Company 

Sheet two, column A, row 24: ABC Company 

 

Is there a way to highlight all duplicated info between the two sheets? 

1 Reply

Resources