Re: Extracting a column from a named range

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
Date: Sat, 24 Dec 2005 07:54:52 -0500

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
.

Follow-Ups:
- Re: Extracting a column from a named range
  - From: Ron Rosenfeld

References:
- Extracting a column from a named range
  - From: Andy Chan

Prev by Date: Re: Batch Naming of ranges
Next by Date: Re: Extracting a column from a named range
Previous by thread: Extracting a column from a named range
Next by thread: Re: Extracting a column from a named range
Index(es):
- Date
- Thread