RANK function
 

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?

RANK function
 

Generally, simple formulas calculate more quickly than array-formulas.
Bob Umlas
Excel MVP
"Dave F" wrote in message
ups.com...
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?

RANK function
 

Unless you're going to use thousands of these formulas, or your going to
expand the range to thousands of rows, the difference would be
inconsequential.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Dave F" wrote in message
ups.com...
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?

RANK function
 

I would say that whenever possible use the non array version because it's
easier to edit and you can't just chop of 4 rows of an multiple cell array
entered formula

--


Regards,


Peo Sjoblom


"RagDyeR" wrote in message
...
Unless you're going to use thousands of these formulas, or your going to
expand the range to thousands of rows, the difference would be
inconsequential.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Dave F" wrote in message
ups.com...
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?

RANK function
 

In general terms I do agree with you Peo,
however, I must say that it's *easier* to edit this type of array range
formula then a non-array range!

Just select *any single* cell in the range, revise it, and CSE, and *every*
formula in the range is automatically updated.

The size change is a bit more convoluted.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" wrote in message
...
I would say that whenever possible use the non array version because it's
easier to edit and you can't just chop of 4 rows of an multiple cell array
entered formula

--


Regards,


Peo Sjoblom


"RagDyeR" wrote in message
...
Unless you're going to use thousands of these formulas, or your going to
expand the range to thousands of rows, the difference would be
inconsequential.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Dave F" wrote in message
ups.com...
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?