Will an Array Formula work here?

  • Thread starter Thread starter Rob Gould
  • Start date Start date
R

Rob Gould

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
 

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

Validation list with array formulaes 6
Help needed 0
Finding Text within an Array 2
Formula to find the last number of a column (lower cell) 1
Conditional Formatting Minimim Value 2
I think an easy Conditional Formatting ? 4
Formula Result = Volatile ?? 3
removing a cell from an array 1

Back
Top