Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!! |
#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 "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!! |
#3
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database comparison challenge! | Excel Discussion (Misc queries) | |||
Comparison / Check Off between 2 excel sheets. HELP NEEDED! | Excel Worksheet Functions | |||
COUNTIF with compound comparison | Excel Worksheet Functions | |||
Comparison of data between three spreadsheets | Excel Worksheet Functions | |||
How do I paste several files together for comparison? | Excel Discussion (Misc queries) |