View Single Post
  #2   Report Post  
ScottO
 
Posts: n/a
Default

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