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