ExcelBanter - Difference between 2 workdheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Difference between 2 workdheets (https://www.excelbanter.com/excel-worksheet-functions/129461-difference-between-2-workdheets.html)

Rajula

Difference between 2 workdheets

Hi All,

Is there a way to find difference between 2 worksheets in Excel.

ufo_pilot

Difference between 2 workdheets

you could insert another worksheet ( sheet3)
then put this in A1
=IF(Sheet1!A1=Sheet2!A1,"","NO MATCH")
and drag down and accross
when done delete sheet3

"Rajula" wrote:

Hi All,

Is there a way to find difference between 2 worksheets in Excel.

All times are GMT +1. The time now is 07:27 AM.