Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there any advantage to using rank as a non-array formula, as in
=RANK(A1,$A$1:$A$18) (entered in B1 and filled down to B18)? Ordinarily I would use it as an array formula: {=RANK(A1:A18,A1:A18)} However the documentation I have recently seen on this function suggests using it in a non-array manner. Thoughts? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rank function | Excel Worksheet Functions | |||
RANK Function | New Users to Excel | |||
Rank Function | Excel Discussion (Misc queries) | |||
Need help with RANK function | Excel Worksheet Functions | |||
Rank Function | Excel Worksheet Functions |