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 |