Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a huge spreadsheet that contains only 7 columns. I don't want to
change the information in the 1st and last colums. The data in the middle 5 columns are randomly entered (numbers) and I need to sort them from lowest to highest keeping them in the rows they were entered in. The first column is a date, all the rest are 1 or 2 digit numbers varying from 1 to 59. I only want to change the order of each row to sort the middle 5 fields in low to high sequence WITHOUT having to do each row separately. I already know how to do that. I cannot find a way to conduct this operation enmass. Can anyone help? -- big Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting rows into a row | Excel Discussion (Misc queries) | |||
sorting rows | Excel Worksheet Functions | |||
Sorting Rows | Excel Discussion (Misc queries) | |||
Sorting rows | Excel Worksheet Functions | |||
sorting rows | Excel Worksheet Functions |