Compare parts of two sheets
 

Hi
I have sheets (large) that contain same information "blocks", but in
different lokations. Ist here a way to compare that they contain the same
information. info being numbers and text.
Thanks
Kalevi

One way ...
Assuming that the two blocks are called Range1 and Range2, then the
array formula =AND(Range1=Range2) should do it. Don't forget to
commit with Ctrl+Shift+Enter.
Rgds,
ScottO


"Kalevi" wrote in message
...
| Hi
| I have sheets (large) that contain same information "blocks", but
in
| different lokations. Ist here a way to compare that they contain
the same
| information. info being numbers and text.
| Thanks
| Kalevi
|
|