Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The only way that I know how to sort data (left to right) for each
individual row is to use these formulas: =SMALL($B2:$D2,1) =SMALL($B2:$D2,2) =SMALL($B2:$D2,3) Where B2:D2 is the location of the data to sort. And then I would copy these formulas down for each row of data in my spreadsheet. This works well if the data is located in a few columns like the example above. But the formula is a pain to use if there are many, many columns of data for each row. Is there a more practical way that I can sort each individual row of data left to right? -- tb |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
ex)
=SMALL(range,COLUMNS($A$1:A1)) and Copy to the right. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SORT BY: left to right | Excel Worksheet Functions | |||
Macro to sort numeric rows left to right | Excel Discussion (Misc queries) | |||
Sort Left-Right & Up-Down | Excel Worksheet Functions | |||
SORT RIGHT-TO-LEFT IN EXCEL | Excel Worksheet Functions | |||
Sort Left to Right | Excel Discussion (Misc queries) |