Re: Extracting a column from a named range

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Dear Ron,

Yes! That's what I want! Thanks!

Best Regards,
Andy

"Ron Rosenfeld" <ronrosenfeld@xxxxxxxxxx>
???????:vs2rq1l2u1688ohv17buttc424t6pgvada@xxxxxxxxxx
> On Sat, 24 Dec 2005 23:06:05 +0800, "Andy Chan"
> <chankhandy-msnewsgroup@xxxxxxxxxxxx> wrote:
>
>>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?
>>
>>
>
> If I understand you correctly, you wish to use the name Scores on each of
> several sheets, and have it refer the that sheet only.
>
> One way to do this is to enter three names:
>
> Navigate to Sheet1 and then define a name:
>
> Instead of NAMEing as Scores, use the NAME Sheet1!Scores and set it equal
> to
> A1:B10.
>
> Then navigate to Sheet2 and define a name as Sheet2!Scores referring to
> Sheet2!A1:B10.
>
> The same for Sheet3.
>
> If you are on the 'native' ***, you can refer to just Scores -- e.g
> =MEDIAN(Scores).
>
> If you are on, let us say, Sheet1 and you want to refer to sheet3, you
> could
> use the formula: =MEDIAN(Sheet3!Scores)
>
>
> --ron


.

Quantcast