how to reposition the dataset from top to bottom in a column?
 

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.

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.