Hi Frick,

I don't think that you are making any errors. If the SMALL function does
not find enough elements in the array it returns a #Num error which
overrides the other numbers being returned. That is why I suggested putting
it in a hidden row so that you can account for it being an error value when
you refer to it. Send me an e-mail by replacing the part after the @ as my
signature suggests and I will send you demonstration sheet that shows what I
intended.

I just noticed when writing the above that I had made mistakes in my
signature address which I have now corrected.
--
HTH

Sandy

with @tiscali.co.uk


"Frick" wrote in
message ...

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