Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort records that are on two lines in a spreadsheet?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort records that are on two lines in a spreadsheet?
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort records that are on two lines in a spreadsheet?
Add the record number to the blank rows in first column.
How to do.......... Select column A and F5SpecialBlanksOK Enter an = sign in the active cell then point to cell above and hit CTRL + ENTER Copy column A and in place paste specialvaluesokesc Gord Dibben MS Excel MVP On Tue, 22 Aug 2006 09:36:02 -0700, 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lines in a spreadsheet | Excel Discussion (Misc queries) | |||
link a entire line in Excel to a spreadsheet I sort? | Excel Discussion (Misc queries) | |||
sort excel spreadsheet with hyperlink | Excel Discussion (Misc queries) | |||
how do I set up a excel spreadsheet to auto sort data in order | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions |