View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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.