Re: Pass an array to Rank

Hi Biff!

Unfortunately, I have no idea. Does the solution have to involve the
RANK function or are you willing to use another alternative to get
ranking?

In article <Oj312pDfFHA.1412@xxxxxxxxxxxxxxxxxxxx>,
"Biff" <biffinpitt@xxxxxxxxxxx> wrote:

> Hi Folks!
>
> Anyone know how to pass an array of values as the ref argument of the Rank
> function without hardcoding or using a range reference?
>
> Assume I have this array of values generated by another formula:
> {71;66;83;71;84}
>
> How do I pass that array to Rank?
>
> I can get the array passed but then the formula #VALUE! errors:
>
> =RANK(71,{71;66;83;71;84})
>
> I've tried using a name for the array, Indexing, Indirect ???
>
> I've never seen this done but I'm not certain that it can't be done.
>
> Biff
.

Loading