F
Faraz A. Qureshi
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
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