How to locate differences between two sheets/ranges?

[Guest]

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

 

[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.

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.

 

[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

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.

 

[Guest]

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

 

[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.

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!