SOLVED

Excel 2007 comparing sheets

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

@jjesposito 

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.