| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Side by Side with 3 simulatanous sheets scrolling | Excel Worksheet Functions | |||
| Compare 2 column list across 2 sheets | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| How do I compare two columns on seperate sheets and replace text . | Excel Worksheet Functions | |||
| how do i compare 2 spread sheets if the content of a cell is avai. | Excel Worksheet Functions | |||
Hybrid Mode
