Comparison

C

chartasap

Hello --

Is there a way i can compare two spreadsheets of similar data but different
dates (spreadsheet 1 is from 6/20 and spreadsheet 2 is from 7/19) to pinpoint
where there have been any modifications if any?

Thank you!!
 
M

Mike

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
 
C

chartasap

Mike if the result is 'true' does that mean that the values compared are the
same?

chartasap
 
Top