Hi All, Is there a way to find difference between 2 worksheets in Excel.
U ufo_pilot Feb 6, 2007 #2 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
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
