Instead of using MIN, use SMALL:

This is the same as using MIN:

=SMALL(W68:INDEX(W1:W68,LARGE(IF(W1:W68<"",ROW
(1:68)),28)),1)

For the second lowest:

=SMALL(W68:INDEX(W1:W68,LARGE(IF(W1:W68<"",ROW
(1:68)),28)),2)

For the third lowest:

=SMALL(W68:INDEX(W1:W68,LARGE(IF(W1:W68<"",ROW
(1:68)),28)),3)

Etc.,Etc..

These are also array formulas.

Biff

-----Original Message-----
Thanks to 'Biff', I was able to get the lowest result
based on the previous
28 cells... and I thought it would be easy to convert
that array so that I
could also get the second lowest in the same 28 cells.
Not quite as easy as
I thought.

Can anyone help?

The original was:

{=MIN(W68:INDEX(W1:W68,LARGE(IF(W1:W68<"",ROW
(1:68)),28)))}

and this gave me the lowest in the range.


.