How do I automatically compare 2 versions of a spreadsheet
 

I need to compare a previous spreadsheet with the current spreadsheet
automatically (200 rows x 30 columns) to see what has changed between
versions. How can I do this easily.

How do I automatically compare 2 versions of a spreadsheet
 

Hi,
try one of these two methods

1

In Sheet1, enter:
=IF(ISNA(MATCH(C1,Sheet2!C:C,0)),"yes","")

2

create a third spreadsheet and enter
=exact(
click on first spreadsheet and select the first cell you are comparing.
click on third spreadsheet and enter
,
click on second spreadsheet and select the first cell you are comparing.
click on third spreadsheet and enter
)
then hit the enter key.
Select that cell you just made and highlight down and to the right and hit
control r then hit control d

hope this helps


"Mz2832" wrote:

I need to compare a previous spreadsheet with the current spreadsheet
automatically (200 rows x 30 columns) to see what has changed between
versions. How can I do this easily.