Excel 2007 comparing sheets

Frequent Visitor

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
Best Response confirmed by jjesposito (Frequent Visitor)


Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.