As the title state, I need to figure out how to obtain each value in the array as I copy the formula down the column, or figure out how to make part of a formula not be affected by CSE.
Example:
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]S[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O
[/TD]
[/TR]
</tbody>[/TABLE]
This is in A1:A11 and the code: =IF((A$1:A$11="O");"YES";"NO")
is copied and dragged down from B1:B11. This results in the one "S" saying "NO", but when I put it in array form, it returns all "YES". Is it possible to have it such that it returns the same results as without CSE? Or a way to isolate the formula such that this section of my formula isn't an array?
Example:
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]S[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O[/TD]
[/TR]
[TR]
[TD]O
[/TD]
[/TR]
</tbody>[/TABLE]
This is in A1:A11 and the code: =IF((A$1:A$11="O");"YES";"NO")
is copied and dragged down from B1:B11. This results in the one "S" saying "NO", but when I put it in array form, it returns all "YES". Is it possible to have it such that it returns the same results as without CSE? Or a way to isolate the formula such that this section of my formula isn't an array?