| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sort by info in one column and it stay in line with info
I am doing a spreadsheet with several columns...I want to sort the rows by
info in a certain column...I want each rows' info to stay in line while i sort by that certain column...can this be done? Also more than 1 column contains numbers and the column I want to sort by contains dates..I dont want to sort by the other numbers in different columns...please advise |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sort by info in one column and it stay in line with info
Just make sure you select all the columns to be in the sort range before
DataSort and picking the column(dates column) to sort on. Gord Dibben MS Excel MVP On Fri, 9 Mar 2007 14:33:08 -0800, stephanie <stephanie @discussions.microsoft.com wrote: I am doing a spreadsheet with several columns...I want to sort the rows by info in a certain column...I want each rows' info to stay in line while i sort by that certain column...can this be done? Also more than 1 column contains numbers and the column I want to sort by contains dates..I dont want to sort by the other numbers in different columns...please advise |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I sort by info in one column and it stay in line with i
Thank you very much!! That works great!!!
"Gord Dibben" wrote: Just make sure you select all the columns to be in the sort range before DataSort and picking the column(dates column) to sort on. Gord Dibben MS Excel MVP On Fri, 9 Mar 2007 14:33:08 -0800, stephanie <stephanie @discussions.microsoft.com wrote: I am doing a spreadsheet with several columns...I want to sort the rows by info in a certain column...I want each rows' info to stay in line while i sort by that certain column...can this be done? Also more than 1 column contains numbers and the column I want to sort by contains dates..I dont want to sort by the other numbers in different columns...please advise |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort column and take row info with it. | Excel Discussion (Misc queries) | |||
| varying validation info based on preceding info | Excel Discussion (Misc queries) | |||
| Sort info | Excel Worksheet Functions | |||
| Tables, How do I make new info push existing info to the next row? | Excel Worksheet Functions | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Linear Mode
