Re: Extracting a column from a named range

Tech-Archive recommends: Speed Up your PC by fixing your registry

I only want to compute the median of the data in Sheet1 only... But I want
to use the name of the range (Scores)... How can I do it?


"Ron Rosenfeld" <ronrosenfeld@xxxxxxxxxx>
???????:60oqq1pjaugjrrtn9mab4ov7b1ngnmfdmb@xxxxxxxxxx
> On Sat, 24 Dec 2005 07:54:52 -0500, Ron Rosenfeld
> <ronrosenfeld@xxxxxxxxxx>
> wrote:
>
>>On Sat, 24 Dec 2005 19:24:06 +0800, "Andy Chan"
>><chankhandy-msnewsgroup@xxxxxxxxxxxx> wrote:
>>
>>>Dear all,
>>>
>>> I have named a range "Scores" across 3 sheets (i.e.
>>>Sheet1:Sheet3!$A$1:$B$10). How can I find the median of values in
>>>"Scores"
>>>in Sheet1 ONLY? I don't know how to provide the target range in the
>>>function
>>>MEDIAN().
>>>
>>>Best Regards,
>>>Andy Chan
>>>
>>
>>
>>=MEDIAN(Sheet3:Sheet1!A1:B10)
>>
>>
>>--ron
>
> I neglected to mention that you can define scores as that cell reference:
>
> scores =Sheet3:Sheet1!$A$1:$B$10
>
>
> --ron


.

Quantcast