Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
=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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
Help with array formula | Excel Worksheet Functions | |||
Array Formula | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) |