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.
|