Sorting in Numerical Order

[nycto87]

I need to do this for an assignment and it isn't working. For example, I have
2 rows of numbers, each row about 15 columns in length and each number has
it's own designated cell. These numbers are not in numerical order.

I need to sort these rows and columns so that they are both in numerical
order with each other, for example:
15 20 25 30 35 40
45 50 55 60 65 70

However, I can only get the first row to be in numberical order by itself
and the second row doesn't order at all, like this:
15 25 30 45 60 65
40 50 20 70 55 35

I know I could just place the second row next to the first and sort that way
and then cut and paste back, however the data sample I am working with has
over 300 numerical characters and this would take way too long.

I'm using the Excel 2003 version and i've gone into data -> sort and tried
every combination. Please help - this is driving me crazy.

 

[Bernie Deitrick]

nycto,

Try selecting just one row at a time, and sorting them individually.

HTH,
Bernie
MS Excel MVP

 

[nycto87]

Hi Bernie,

It's works when I sort the rows individually but i need both rows to
correspond with each other - so if there is a lower value in the second row
and I want to numerically order both rows together it should go up to the
first row, but this isn't working

 

[Bernie Deitrick]

Manually: Move the second row up, to the end of the first row, sort the single row, then grab the
second half and move it back.

If you want to have an autosorted range, then you could use formulas. Let's say that your data is
in B34, and you want a sorted list to start in, say, cell B7.

In B7, enter the formula

=SMALL($B$3:$P$4,(ROW()-ROW($B$7))*COLUMNS($B$3:$P$4)+COLUMN(B7)-COLUMN($A$7))

and copy to B78.

HTH,
Bernie
MS Excel MVP

 

[patio]

Hi, I am having the same problem as you. What did you do to to get all the
rows and columns in numerical order? Thanks!