| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort each line horizontally and separately
I have a worksheet with 200 lines. I would like to sort each line
horizontally, so that the lowest number in each line is represented in column A, and the second lowest number in column B and so on. Can this be done for all the lines at the same time? Before sorting A B C Line 1 2 1 7 Line 2 5 8 1 After sorting A B C Line 1 1 2 7 Line 2 1 5 8 -- Best regards Nils |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i sort 2 colums so that the same values line up | Excel Discussion (Misc queries) | |||
| Can I sort horizontally? | Excel Discussion (Misc queries) | |||
| Sort horizontally? | Excel Discussion (Misc queries) | |||
| resize line or arrow shape horizontally in Excel 2007 | Excel Discussion (Misc queries) | |||
| a blue line running horizontally through a few cells what is it | New Users to Excel | |||
Threaded Mode
