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
DataSort and select "Descending" and OK out.

Mike Rogers

"wannabe68" wrote:

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.

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.

"Mike Rogers" wrote:

wannabe68

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

Mike Rogers

"wannabe68" wrote:

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

Thanks for posting back. Dave has the solution you need.

Mike Rogers

"wannabe68" wrote:

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.

"Mike Rogers" wrote:

wannabe68

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

Mike Rogers

"wannabe68" wrote:

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.

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.



wannabe68 wrote:

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.

--

Dave Peterson

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

On Sun, 13 Apr 2008 14:32:02 -0700, wannabe68
wrote:

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.

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.

On Apr 14, 3:56*am, Gord Dibben <gorddibbATshawDOTca wrote:
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

On Sun, 13 Apr 2008 14:32:02 -0700, wannabe68



wrote:
I have ten rows of numbers in sequential order. *I want toreversethe
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.- Hide quoted text -

- Show quoted text -

Hi,
Filord does it in one click, www.filord.com