Array Problem 1

[clifftech]

Help please-

I have a single column, 10 row vertcial array that I need to determine the maximum value between (including) the 2nd and 8th row of the array. (The array size and row pairs often change).

Is it possible to do this using a array formula instead of vba?

I have tried to use an array formula using the index function but have not had any luck.

 

[GlennUK]

No array needed, it's jsut a simple(ish) MAX function, with INDEXes:

=MAX(INDEX(A1:A10,2):INDEX(A1:A10,8))

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[clifftech]

Works great...thanks so much.