HOW TO CONSTRUCT AN ARRAY FORMULA
 

Sure would oblige if one would kindly provide the code for developing a UDF
for simple formula of reversing the column values like the following:

=OFFSET($A$1,ROWS($A$1:$A$20)-ROWS($B$1:B1),0)

Thus, if a UDF like the following, is entered in an array form:
{=REVCOL(A1:A20)}
on the range B1:B20, the B1:B20 would represent the data of A1:A20 but in
the reverse order.

Thanx in advance,
Best Regards,

Faraz

HOW TO CONSTRUCT AN ARRAY FORMULA
 

Entering in B1 and filled down to B20 this normal (not array) formula gives
A1:A20 in reverse order:
=INDEX($A$1:$A$20,21-INDIRECT("A"&ROW()))


--
Regards!
Stefi



€žFaraz A. Qureshi€� ezt Ã*rta:

Sure would oblige if one would kindly provide the code for developing a UDF
for simple formula of reversing the column values like the following:

=OFFSET($A$1,ROWS($A$1:$A$20)-ROWS($B$1:B1),0)

Thus, if a UDF like the following, is entered in an array form:
{=REVCOL(A1:A20)}
on the range B1:B20, the B1:B20 would represent the data of A1:A20 but in
the reverse order.

Thanx in advance,
Best Regards,

Faraz

HOW TO CONSTRUCT AN ARRAY FORMULA
 

I know several others as well Stefi. It is the programming section I have my
query placed! A code for a UDF is required not a formula.
--
Thanx in advance,
Best Regards,

Faraz


"Stefi" wrote:

Entering in B1 and filled down to B20 this normal (not array) formula gives
A1:A20 in reverse order:
=INDEX($A$1:$A$20,21-INDIRECT("A"&ROW()))


--
Regards!
Stefi



€žFaraz A. Qureshi€� ezt Ã*rta:

Sure would oblige if one would kindly provide the code for developing a UDF
for simple formula of reversing the column values like the following:

=OFFSET($A$1,ROWS($A$1:$A$20)-ROWS($B$1:B1),0)

Thus, if a UDF like the following, is entered in an array form:
{=REVCOL(A1:A20)}
on the range B1:B20, the B1:B20 would represent the data of A1:A20 but in
the reverse order.

Thanx in advance,
Best Regards,

Faraz