Hi

=IF(COUNTIF(Sheet1!A1:A10,"NEW")0,"NEW","SAME")

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Rob Gould" wrote in message
oups.com...
Hi all,

I have a formula in cells A1 to A10 which displays the word "SAME"
under normal conditions. If the source for one of those cells changes,
the cell will display "NEW". On a second worksheet, I want a
single cell to display either a blank if all A1 to A10 on sheet 1 read
"SAME" or "NEW" if one or more of those cells displays
"NEW".

Confusing? Hope not. Is there a way to do this with arrays or
similar?

Thanks.

Rob