Hi,
I've used this Median function a number of times with great success:
=MEDIAN(IF(D173
191>=TRANSPOSE(ROW(INDIRECT("1:"&MAX(D173191)))),$B$173:$B$191))
Where D173191 are the Frequencies and $B$173:$B$191 are the Values.
Obviously I'm really happy it works but I'd like to know how. Arrays seem very powerful but I've yet to find much in the way of help / tutorials on them.
Yours Dumbly <:0S
Jim
I've used this Median function a number of times with great success:
=MEDIAN(IF(D173
191>=TRANSPOSE(ROW(INDIRECT("1:"&MAX(D173191)))),$B$173:$B$191))Where D173
191 are the Frequencies and $B$173:$B$191 are the Values.Obviously I'm really happy it works but I'd like to know how. Arrays seem very powerful but I've yet to find much in the way of help / tutorials on them.
Yours Dumbly <:0S
Jim