Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming |