Compare cells on many pages

  • Thread starter Thread starter MartinFilteau
  • Start date Start date
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
 
Martin,

Try-

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

regards,

JohnI
 
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

Code to format cells on several worksheets 2
SUMIF function and cell /sheet reference 3
alter code to apply to range (links cells w/ row insertions) 1
Conditional Concatenate? 2
Copying multiple cells out of multiple worksheets at same time. 1
Hyperlink via indirect cell reference 8
bookkeeping-payment confirmation 7
=Sheet1!A1 - with a blank entry!!! 4

Back
Top