Forum Discussion
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?
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.
1 Reply
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.