floris v wrote:The question is what you want to achieve. Normally, you put data that belongs together in a row, not in a column. That's how databases are designed. In a Calc list of your contacts, the name, address, telephone number, etc, for each contact would appear in a row, not a column. So if you want to use the sort routines in Calc, you should also put the data for each subject or object in a row, not a column. I don't know if there's an easy way to "mirror" your data from rows to columns.
RusselB wrote:Take a look at this attachment, which I sorted and let us know if this is what you would expect from your sample file.
If this is not what you would expect, then please upload another sample file, but include examples of what the data would look like after sorting.
RusselB wrote:I understand now what it is you are looking for, unfortunately Calc doesn't have a built-in function that would do this for multiple rows.
You could use Data -> Sort, changing the Direction in the Options tab to Left to Right (Sort Columns), for each and every row, one at a time.
A macro might be a programmed option, but my knowledge in that area is limited.
These instructions are based on your attachment. In D1, put =MIN(A1:C1). In E1 put =MEDIAN(A1:C1), In F1 put =MAX(A1:C1). Fill the formulas down the column. Columns D-F now contain the sorted numbers in each row.Deese wrote:I have three columns with a one digit number in each row or each column. I am trying to sort the rows left to right by numerical order.
[Tutorial] Ten concepts that every Calc user should knowDeese wrote:I am a new user to spreadsheets,I have only used Calc.
=SMALL($A1:$C1;COLUMN(A1))
Users browsing this forum: Google [Bot] and 11 guests