Scores of a Range Cells. Highest or lowest depending a parameter

[Guest]

How do I get the highest score out or the lowest score of a series, depending
ascending or diescending interest.
Anything like this:
C1:C100=Function[A1:A100;B1] where [A1:A100] are any positive values, B1 is
a parameter - ex.:0 (Zero) must give [B1:B100] result 1 to the lowest
[A1:A100] value and 0 to the Highest [A1:A100] value , or in the other hand
B1 beeing 1 must gives [B1:B100] result 0 to the lowest [A1:A100] value and 1
to the Highest [A1:A100] value.

Anybody can help?

 

[Guest]

Think you could just use the RANK function ..

Eg place in C1: =RANK(A1,$A$1:$A$100)
Copy C1 down to C100. This returns a "descending" ranking, ie the highest
number within A1:A100 will be ranked: 1, with the lowest number ranked: 100
(assuming all 100 source numbers are unique).

And to return the converse, ie an "ascending" ranking,
just place in say, D1: =RANK(A1,$A$1:$A$100,1)
and copy down to D100.

Check up more on RANK in Excel's help