Thanks this helps a lot - one more follow up.
My range isnt in an order. My current formula is
=AVERAGE(VLOOKUP(MROUND(A3,0.125)/100,EMC30,2,0),VLOOKUP(MROUND(A3,0.125),Nomura30,2 ,0),VLOOKUP(MROUND(A3,0.125),UBS30,2,0),VLOOKUP(MR OUND(A3,0.125),Winter30,2,0))
Where is is looking up rates in 4 different sheets and averaging. As Im not
too familiar with Arrays (until I read the article) will it work and can you
show me how ?
Thanks,
Yosef


"tjtjjtjt" wrote:

It compares each value to the minimum value in the range.
Values not greater than the minimum are ignored.
I meant to mention that the formula will return #DIV/0 if all the numbers in
the range are the same.

This article will explain it. Also, try a web search for Array Formulas in
Excel.
http://office.microsoft.com/en-us/as...872901033.aspx
--
tj


"ynissel" wrote:

Wow - I cant believe that worked - but I dont understand the formula. CAn
you try to explain ?
Thanks,
Yosef

"tjtjjtjt" wrote:

This is working after a couple of simple tests:
=AVERAGE(IF(D1:D6MIN(D1:D6),D1:D6))
Use Ctrl+Shift+Enter to input this formula. It will return #VALUE if you
only press enter.
--
tj


"ynissel" wrote:

Is there a function to average a series of numbers but dropping the lowest ?
Thanks,
Yosef