Re: Extracting a column from a named range

Dear Niek,

My situation is like this: I want to maintain a file containing
information of 80 classes of students, the information of students of each
class is contained in one ***. Every *** has a similar structure, say
columns A to I are for name, gender, scores of each subject, etc. For
example, F1:F20 of each *** contain scores of math exams of the
corresponding class. I want to find the 80 medians of scores of math exams,
as well as the overall median. Therefore, I want to name these ranges. Is it
clear? Thanks in advance!

Best Regards,
Andy

"Niek Otten" <nicolaus@xxxxxxxxx> ¼¶¼g©ó¶l¥ó·s»D:O9HjbPKCGHA.2920@xxxxxxxxxxxxxxxxxxxxxxx
> I'm sure it is possible one way or another.
> But i do find you get yourself into trouble by choosing a rather complex
> way to name a range and then want to use that name but mean something
> else.
> The logic escapes me.
> Can you explain what you're trying to do which makes this necessay?
>
> --
> Kind regards,
>
> Niek Otten
>
> "Andy Chan" <chankhandy-msnewsgroup@xxxxxxxxxxxx> wrote in message
> news:43ad63dd$1@xxxxxxxxxxxx
>>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
>>
>>
>
>


.