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.
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.
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
ecox wrote:
> 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.
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
On Tue, 22 Aug 2006 09:36:02 -0700, ecox <[email protected]> wrote:
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks