Sorting Rows- Reverse

  • Thread starter Thread starter wannabe68
  • Start date Start date
W

wannabe68

I have ten rows of numbers in sequential order. I want to reverse the
sequence of numbers. I believe there is a way to do this via the toolbar:
File, edit, view, insert, format, tools, data, etc. I have been searching
for the command, but can not remember where it is. Any help would be
appreciated.
 
wannabe68

If you have sorted them "Ascending", after selecting the ten rows goto
Data>Sort and select "Descending" and OK out.

Mike Rogers
 
Sorry Mike, I didn't make myself clear.
Row has 6,9,2,6,7,4,2
I want to reverse the numbers
2,4,7,6,2,9,6 same order only reversed.
 
Add another column.
Put 1, 2, 3, ..., 10 in those cells
(or even =row() in the top and fill down)

Then sort all your data by this column in descending order.
 
One more method.

In an adjacent column enter this formula then copy down to row 10.

=INDEX($A$1:$A$10,10-(ROW(A1)-1))


Gord Dibben MS Excel MVP
 
Gord Dibben <gorddibbATshawDOTca> wrote:

in past group reply you provided the below formula for transposing
this data from a column
to a row format.

i need to convert your formula so it will work on data that is in
column d, starting at row 25.

the formula works great as long as the data is in column a.

thanks for your help[
bob leonard


John Smith
123 Maple Ave.
Springfield, NJ 081234
123-456-7890
Jane Doe
100 Center Street
Milton, DE 0123456
234-123-0987

In B1 enter:

=INDIRECT("A" & ROWS($A$1:A1)*4-4+COLUMNS($A$1:A1))

The copy B1 to B1 thru E100 or even further.  You will see:

John Smith      123 Maple Ave.  Springfield, NJ 081234  123-456-7890
Jane Doe        100 Center Street       Milton, DE 0123456   
 234-123-0987

Each 4 elements have been moved to a row.  The next step is to take
column D
and split it up.
 
Back
Top