Harlan Grove wrote:
wrote...
. . . (But you cannot use P12:P12 where a single value is expected.)
Not true. [....] In Excel P12 and P12:P12 are semantically identical.
Well, that is certainly what I would like. But I tried P12:P12 in
__some__ context where a single value is expected -- e.g. an arithmetic
expression -- and I thought it failed. However, when I tried it again
just now, it does indeed work -- at least in all the cases I have tried
so far. (I am not trying very hard, since I trust Harlan's insight.)
That is good. IMHO, there is no reason why P12:P12 should not be
treated the same as P12 when a single value is expected. On the other
hand, I can imagine some parsing algorithm taking a short-cut and
refusing a range out-of-hand without seeing if it is single-valued. So
I would not surprise me if there are exceptions to the rule, albeit
undesirable.