sort data in cells in a row
 

I have copied and pasted data in cells in a particular row amongst other rows
not in any order. I would like to know if there is a method other than manual
sorting to place the individual cells in this row in ascending or descending
order, without disturbing the cells in the rest of the rows. And then to skip
to the next row and do the same thing over again. Treating each row
seperately on the same worksheet.

Many thanks
Cactus

Highlight the row you want to sort, then Data Sort choose Continue with
the current selection fromt the pop-up then Options Normal check Sort
left to right OK OK

Vaya con Dios,
Chuck,
CABGx3


"Cactus" wrote in message
...
I have copied and pasted data in cells in a particular row amongst other
rows
not in any order. I would like to know if there is a method other than
manual
sorting to place the individual cells in this row in ascending or
descending
order, without disturbing the cells in the rest of the rows. And then to
skip
to the next row and do the same thing over again. Treating each row
seperately on the same worksheet.

Many thanks
Cactus

On Sun, 5 Jun 2005 17:55:30 -0700, Cactus
wrote:

I have copied and pasted data in cells in a particular row amongst other rows
not in any order. I would like to know if there is a method other than manual
sorting to place the individual cells in this row in ascending or descending
order, without disturbing the cells in the rest of the rows. And then to skip
to the next row and do the same thing over again. Treating each row
seperately on the same worksheet.

Many thanks
Cactus

Select the cells you wish to sort; only one row.

Data/Sort
Continue with the current selection
Sort
Options
Orientation: Sort Left to Right
<OK
<OK

Then select your next row and continue the process.

--ron

Here's a play to try ..
(Link to a sample file is provided below)

Assume source data is in Sheet1, in A1:E5
(Source data is assumed all numbers)

In Sheet1

Put in G1: =A1+COLUMNS($A$1:A1)/10^10
Copy across 5 cols to K1, fill down to K5

This creates a horizontal arbitrary tie-breaker ref table for an *ascending*
sort in say, Sheet2

Similarly,

Put in M1: =A1-COLUMNS($A$1:A1)/10^10
Copy across 5 cols to Q1, fill down to Q5

This creates a horizontal arbitrary tie-breaker ref table for a *descending*
sort in say, Sheet3

In Sheet2

Put in A1:

=INDEX(Sheet1!$A1:$E1,MATCH(SMALL(Sheet1!$G1:$K1,C OLUMNS($A$1:A1)),Sheet1!$G
1:$K1,0))

Copy across to E1, fill down to E5 to populate a range of the same size as
the source data in Sheet1

Sheet2 will return a corresponding auto-horizontal ascending sort of each
row in the source data. The sorting is from left to right, row by row,
independently.

In Sheet3

Put in A1:

=INDEX(Sheet1!$A1:$E1,MATCH(LARGE(Sheet1!$G1:$K1,C OLUMNS($A$1:A1)),Sheet1!$G
1:$K1,0))

Copy across to E1, fill down to E5 to populate a range of the same size as
the source data in Sheet1

Sheet3 will return a corresponding auto-horizontal descending sort of each
row in the source data. The sorting is from left to right, row by row,
independently

Here's a sample file with the implemented construct:
http://flypicture.com/p.cfm?id=59191
(Right-click on the link: "Download File"
at the top in the page, just above the ads)
File: Cactus_wksht_2.xls
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Cactus" wrote in message
...
I have copied and pasted data in cells in a particular row amongst other
rows
not in any order. I would like to know if there is a method other than
manual
sorting to place the individual cells in this row in ascending or
descending
order, without disturbing the cells in the rest of the rows. And then to
skip
to the next row and do the same thing over again. Treating each row
seperately on the same worksheet.

Many thanks
Cactus