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?

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?

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?

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?

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?