Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Rob Gould
 
Posts: n/a
Default 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

  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

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   Report Post  
Jason Morin
 
Posts: n/a
Default

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't Damaeus Excel Worksheet Functions 12 January 23rd 05 05:52 PM
Help with array formula Excel Worksheet Functions 2 January 20th 05 05:17 PM
Array Formula Doug at HAL Excel Worksheet Functions 3 December 21st 04 11:27 AM
Need help troubleshooting an array formula XLXP on Win2K KR Excel Worksheet Functions 1 December 13th 04 08:41 PM
What instead of an array formula part 2 Reg Besseling Excel Discussion (Misc queries) 2 December 10th 04 08:35 AM


All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"