Hi Domenic,

That's Great! Thank you so very much.

Cheers,
Sam

Domenic wrote:
Assuming that you want the MEDIAN for the third column in your named
range 'DATA', try...

A2: 5

(This indicates that you want the MEDIAN for the last 5 numbers.)

B2:

=MATCH(9.99999999999999E+307,INDEX(Data,0,3))

C2:

=MEDIAN(INDEX(Data,B2-MIN(A2,B2)+1,3):INDEX(Data,B2,3))

Note that if there's less than 5 numbers available, the formula will
return the median for those numbers which are available.

Hope this helps!

Hi All,

[quoted text clipped - 15 lines]

Thanks Sam

--
Message posted via http://www.officekb.com