Compare parts of two sheets

  • Thread starter Thread starter Kalevi
  • Start date Start date
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
 
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
|
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing two spreadsheets 2
Excel Comparing two columns 1
Comparing two spreadsheets with pricing information 5
Compare two sheets and combine into one 2
Comparing 2 worksheets in Excel 2007 1
Excel vba code to match duplicates 4
Comparing lists of data 7
Comparing data in two columns 1

Back
Top