Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kalevi
 
Posts: n/a
Default 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


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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare Side by Side with 3 simulatanous sheets scrolling John Louis Excel Worksheet Functions 0 October 11th 05 12:31 PM
Compare 2 column list across 2 sheets GerryK Excel Worksheet Functions 1 August 23rd 05 05:21 PM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 06:49 PM
How do I compare two columns on seperate sheets and replace text . hag400 Excel Worksheet Functions 1 December 28th 04 03:32 PM
how do i compare 2 spread sheets if the content of a cell is avai. Hayitsme Excel Worksheet Functions 1 December 17th 04 12:27 AM


All times are GMT +1. The time now is 02:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"