RANK function

[Dave F]

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?

 

[Bob Umlas]

Generally, simple formulas calculate more quickly than array-formulas.
Bob Umlas
Excel MVP

 

[RagDyeR]

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 !
-----------------------------------------------------------------------------------------------

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?

 

[Peo Sjoblom]

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]

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.