Harlan Grove wrote:
"Alan Beban" wrote...

Harlan Grove wrote:

...

On the other hand, if recalc performance is absolutely critical, better
to use 2 formulas/cells per each result plus one extra formula/cell.

G2:
=ROWS(Tbl)

H1:
=VLOOKUP(G$1,Tbl,2,0)

I1:
=MATCH(G$1,INDEX(Tbl,0,1),0)

H2:
=INDEX(Tbl,I2,2)

I2:
=MATCH(G$1,OFFSET(Tbl,I1,0,G$2-I1,1),0)

...

I already mentioned I screwed up the I2 formula. It should be

=MATCH(G$1,OFFSET(Tbl,I1,0,G$2-I1,1),0)+I1


Which of the formulas, if any, are to be array entered?


None. You couldn't test to be sure? You're not sufficiently familiar with
Excel to know yourself? Just a rhetorical question for the benefit of other
readers, and you prefer that device to simply stating none of them need to
be entered as array formulas?

No. You gave me a screwed up formula for I2 and I was just trying to see
why what you provided wasn't working as you suggested it would.


Which get copied where to display the output?


I considered my previous response an extension of my response before that,
so implicit to drag the formulas in row 2 down until they return error
values.


I already did that with the only formula you provided for I2 and it
produced garbage; so yes indeed, I and any one else trying to use what
you provided needed something more explicit. Our fault, of course.

I must endeavor to remember that you need everything explicit.

No; just endeavor to test your stuff before you post it so you won't
have to embarrass yourself by trying to shift the responsibility to me
when it doesn't work.

Alan Beban