how to reposition the dataset from top to bottom in a column?
If data in B1 to B20, try this in C1, and copy down to C20:
=INDEX($B$1:$B$20,20-(ROW(A1)-1))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"arizona" wrote in message
...
I need to change the datas from top to bottom position or reverse the
position of dataset without doing the ascending or descending order of the
dataset.
|