Comparison
 

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

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

"chartasap" wrote:

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

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

chartasap

"Mike" wrote:

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

"chartasap" wrote:

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