The first formula works great.

the second one is not returning the correct value. When J7=S I get
#Num and when J7=T I get a value of 6.12.

I entered the array correctly with CTRL-SHIFT-ENTER so that's not the
problem. I'm having a hard time understanding the formula as I have
not worked with array's before.

Can you look it over and see if I'm making some kind of error. I
susspect if we can get it too work for removing the lowest then iit
should not be difficult to remove the lowest two and lowest three.

Thanks again for your help.


--
Frick
------------------------------------------------------------------------
Frick's Profile: http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=493231