Compare parts of two sheets

K

Kalevi

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
 
S

ScottO

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


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