Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why doesn't RANK(1,{2,1}) work?
I am using Office Excel 2003. According to the offline Help page, the
second argument of RANK() is (emphasis added): "an __array__ of, or a reference to, a list of numbers". So why does the following result in a syntax error? =rank(1, {2,1}) Isn't {2,1} "an array of" a list of numbers? Obviously, I can work around this by putting 2 and 1 into B1:B2, for example, and using =RANK(1,B1:B2). But that is "a reference to" a list of numbers. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why doesn't RANK(1,{2,1}) work?
joeu2004 wrote...
I am using Office Excel 2003. According to the offline Help page, the second argument of RANK() is (emphasis added): "an __array__ of, or a reference to, a list of numbers". So why does the following result in a syntax error? =rank(1, {2,1}) .... Long-standing error in Excel's help files. One of many. A cynic might think Microsoft's apparent lack of interest in fixing this might have something to do with their overwhelming market share. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why doesn't RANK(1,{2,1}) work?
On Feb 13, 12:16*pm, Harlan Grove wrote:
joeu2004 wrote... So why does the following result in a syntax error? =rank(1, {2,1}) Long-standing error in Excel's help files. One of many. A cynic might think Microsoft's apparent lack of interest in fixing this might have something to do with their overwhelming market share. Thanks. Exactly the answer I expected, cynical comment and all ;-). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RANK, duplicate ranking but no gaps in rank | Excel Worksheet Functions | |||
Rank(A1,C1:C5) - Rank using 2 ranges | Excel Worksheet Functions | |||
Rank where lowest value is highest rank | Excel Worksheet Functions | |||
Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. | Excel Worksheet Functions | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |