HOW TO CONSTRUCT AN ARRAY FORMULA

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
 
S

Stefi

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:
 
F

Faraz A. Qureshi

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top