How to locate differences between two sheets/ranges?

G

Gryzor

Well, here's my problem: each day here at work I receive a file with updated info on specific data. Form is always the same -specific number of columns with the same type of data, only the number of rows may change. However, every day I have to go through the data to see what has been changed and/or what has been added/dropped.

Is there any way to do this easily?

Kind regards
Th
 
A

Andy B

Hi

Have a look here for some ideas. I'm sure one of them will suit:
http://www.cpearson.com/excel/duplicat.htm

--
Andy.


Gryzor said:
Well, here's my problem: each day here at work I receive a file with
Click to expand...
updated info on specific data. Form is always the same -specific number of
columns with the same type of data, only the number of rows may change.
However, every day I have to go through the data to see what has been
changed and/or what has been added/dropped.
 
P

Paul Falla

One way in which to do it is to insert a helper column and
place an IF statement in it to check for changes.
Something like the statement below might help.

=IF(A2<>'N:\Daily Spreadsheets\[Yesterdays Sheet.xls]
Sheet1'!A2,"Changes made ","No Change")

Where the first A2 mentioned is cell A2 in today's
worksheet and the stuff after the <> is the path to
yesterday's sheet, and the cell to be compared.

The above IF statement can then be copied down all the
rows in today's worksheet, and then filtered to show those
cells which show "Changes made".

There may well be other ways of doing this, but this was
the simplest I could think of to help you out

Hope this helps

Paul Falla
-----Original Message-----
Well, here's my problem: each day here at work I receive
Click to expand...
a file with updated info on specific data. Form is always
the same -specific number of columns with the same type of
data, only the number of rows may change. However, every
day I have to go through the data to see what has been
changed and/or what has been added/dropped.
 
G

Gryzor

Hello Andy,

Many thanks for the prompt reply... Indeed, this looks like an interesting article and probably I could work something out with its help. If anyone's got a quicker solution (I've found some plugins, but doing much more and costing more than I'd want) I'd be glad to know!

Cheers
Th
 
A

Andy B

Hi

If Paul's solution is not of use to you, post some plain text data showing
what you have and what you want. How many columns are involved? Do they all
need to be identical?

--
Andy.


Gryzor said:
Hello Andy,

Many thanks for the prompt reply... Indeed, this looks like an interesting
Click to expand...
article and probably I could work something out with its help. If anyone's
got a quicker solution (I've found some plugins, but doing much more and
costing more than I'd want) I'd be glad to know!
 
Top