Compare cells on many pages

M

MartinFilteau

Hi,
I would like to compare if a cell has the same value (text) on each
spreadsheets.
If on each sheet we get at A1 "ABCD"
=Sheet1!A1=Sheet2!A1 --> Give me True
=Sheet1!A1=Sheet2!A1=Sheet3!A1 --> Give me False.

Any suggestions.

Martin
 
J

JohnI in Brisbane

Martin,

Try-

=AND(Sheet1!A1=Sheet2!A1,Sheet1!A1=Sheet3!A1)

regards,

JohnI
 
Top