Comparison:Is there a way i can compare two spreadsheets of similar data

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