Re: Is it possible to use wildcard characters in array formulas?

From: Leo Heuser (leo.heuser_at_NOSPAMadslhome.dk)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 12:15:26 +0200

"Harlan Grove" <hrlngrv@aol.com> skrev i en meddelelse
news:Tyyzc.5955$H4.323@www.newsranger.com...
> "Leo Heuser" <leo.heuser@NOSPAMadslhome.dk> wrote...
> ...
> >Ah yes, one more call. . . . Are you saying, that
> >MIN(ROW(PossiblyMulticellRange)) and
> >CELL("Row",PossiblyMulticellRange)
> >do not always return the same result, array entered or not?
>
> They return the same results.

You mentioned 2 points, that in your opinion made CELL() superior to the
MIN() solution. It's the second point "and in and of itself needing array
entry",
that I don't understand, and your answer above leaves me no wiser.

>The one fewer call isn't so much about recalc
> speed as it is avoiding the 7 nested call limit. Fewer nested calls always
> provides more flexibility.

Yes, I'm aware of that. I just forgot it at the moment. My "Ah yes" was
supposed to mean that.

Apparently you missed my question:
"I'm probably being dense here, but would you please go into details about,
why you don't consider the formula robust?"

LeoH

Quantcast