Will an Array Formula work here?
 

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

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

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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

.