Well, that's how SMALL and LARGE work if there are
duplicates.

What to do about it depends on what you're trying to do.
How many "next lowest" values do you want to extract?

Biff

-----Original Message-----
This works, but when I have multiple cells with the same
entry.... (In my
first set, I have the same low number of 3226 - 3 times),
I have to go and
ask for the 4th smallest, to get the actual 2nd lowest
entry.

To cure this, would I have to put in multiple IF
statements, or is there an
easier way?

"Biff" wrote:

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.


.


.