Hi, I know there is an existing median if thread, but it is not resolving the problem I have.
My formula below is as follows:
=MEDIAN(IF(Test!$G$2:$G$13215=B14,Test!$B$2:$B$13215))
I seem to be having difficulties referencing data on another worksheet. The formula is on the same sheet that B14 is on.
I enter it as an array format, but I get #NUM! as a result.
Any help? Thanks in advance,
JRudner
My formula below is as follows:
=MEDIAN(IF(Test!$G$2:$G$13215=B14,Test!$B$2:$B$13215))
I seem to be having difficulties referencing data on another worksheet. The formula is on the same sheet that B14 is on.
I enter it as an array format, but I get #NUM! as a result.
Any help? Thanks in advance,
JRudner