Hi daddylonglegs,

Perfect! Thank you very much for your time and assistance.

Cheers,
Sam

daddylonglegs wrote:
For the first column of data

=MEDIAN(OFFSET(INDEX(INDEX(data,0,1),COUNT(INDEX( data,0,1))),,,MAX(-COUNT(INDEX(data,0,1)),-5),))

This gives the median of the last 5 numbers in the column, assuming the
rules you outlined are obeyed. If there are less than 5 values it gives the
median of whatever numbers there are.

For column 2 change all 1s to 2s or you could use some sort of COLUMN
reference to apply one formula which can be copied across

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200611/1