LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,059
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
RANK, duplicate ranking but no gaps in rank arron laing Excel Worksheet Functions 4 June 14th 06 07:57 AM
Rank(A1,C1:C5) - Rank using 2 ranges goofy11 Excel Worksheet Functions 3 June 9th 06 06:03 AM
Rank where lowest value is highest rank mile3024 Excel Worksheet Functions 2 December 9th 05 10:57 PM
Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(. Emmanuel Excel Worksheet Functions 3 November 12th 05 03:33 PM
Rank items, select one start date, have remaining dates follow based on rank rob normerica Excel Discussion (Misc queries) 1 August 15th 05 09:36 PM


All times are GMT +1. The time now is 10:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"