Thread: Scores of a Range Cells. Highest or lowest depending a parameter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cradino cradino is offline
external usenet poster
  
Posts: 10
Default Scores of a Range Cells. Highest or lowest depending a parameter
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?
Reply With QuoteReply With Quote