Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |