How do I sort records that are on two lines in a spreadsheet?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ecox - 22 Aug 2006 17:36 GMT

I have a spreadsheet that I am trying to sort. The records are on two rows
with the first row, first column containing the record number. I want to
sort the file and maintain the records.

Reply to this Message

Pete_UK - 22 Aug 2006 17:52 GMT

Assuming you have contiguous data in the second column, insert a new
third column (temporarily), then click on your first record number
(assume this is A2) and press F5 - select Special then Current Region.
Press F5 again, select Special then Blanks. Then:

type the = sign,
click on A2 (or the cell above),
type +0.1
press CTRL-ENTER

This will make all the blank cells 0.1 higher than the record number
above it. Fix the values, get rid of the temporary third column and
sort.

Hope this helps.

Pete

> I have a spreadsheet that I am trying to sort. The records are on two rows
> with the first row, first column containing the record number. I want to
> sort the file and maintain the records.

Reply to this Message

Gord Dibben - 22 Aug 2006 20:43 GMT

Add the record number to the blank rows in first column.

How to do..........

Select column A and F5>Special>Blanks>OK

Enter an = sign in the active cell then point to cell above and hit CTRL + ENTER

Copy column A and in place paste special>values>ok>esc

Gord Dibben MS Excel MVP

>I have a spreadsheet that I am trying to sort. The records are on two rows
>with the first row, first column containing the record number. I want to
>sort the file and maintain the records.

Reply to this Message