Sort in ascending order
lorenzo31600
Posted messages
3
Status
Member
-
Mike-31 Posted messages 18405 Registration date Status Contributor Last intervention -
Mike-31 Posted messages 18405 Registration date Status Contributor Last intervention -
Hello,
I haven't found any answer that works for a very simple operation on Open Office.
It's simply about sorting horizontally in ascending order in a table on Calc.
For example, 41 4 78 33 19
would give: 4 19 33 41 78
If you have the solution, thank you in advance.
I haven't found any answer that works for a very simple operation on Open Office.
It's simply about sorting horizontally in ascending order in a table on Calc.
For example, 41 4 78 33 19
would give: 4 19 33 41 78
If you have the solution, thank you in advance.
4 answers
Hello.
It's great, retirement! Especially in the Antilles... :-)
Raymond (INSA, AFPA, CF/R)
- Select the 5 numbers from row 1
- Data / Sort / Sort Criteria / Sort by / Row 1
- Data / Sort / Options / Direction / Left to right
It's great, retirement! Especially in the Antilles... :-)
Raymond (INSA, AFPA, CF/R)
Hello,
for example you have your data between B2 and K2, you can use the SMALL function
if your first formula is in column 2, that is B
=SMALL($B$2:$K$2,COLUMN()-1)
if your formula is in column F
=SMALL($B$2:$K$2,COLUMN()-5)
if you have empty cells you can add error handling to avoid displaying #VALUE!
=IF(ISERROR(SMALL($B$2:$K$2,COLUMN()-1)),"",SMALL($B$2:$K$2,COLUMN()-1))
--
See you later
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
for example you have your data between B2 and K2, you can use the SMALL function
if your first formula is in column 2, that is B
=SMALL($B$2:$K$2,COLUMN()-1)
if your formula is in column F
=SMALL($B$2:$K$2,COLUMN()-5)
if you have empty cells you can add error handling to avoid displaying #VALUE!
=IF(ISERROR(SMALL($B$2:$K$2,COLUMN()-1)),"",SMALL($B$2:$K$2,COLUMN()-1))
--
See you later
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
Hello,
I tried the first solution but I keep getting error message 501. The second solution works but only for one line... I would like to apply it to the entire table!
Thank you for the answers!
I tried the first solution but I keep getting error message 501. The second solution works but only for one line... I would like to apply it to the entire table!
Thank you for the answers!
Re,
you must have an imbalance between your beaches or with your starting line, it would be best to have an example of an anonymized file that you can attach from this link
https://www.cjoint.com/
--
A+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
you must have an imbalance between your beaches or with your starting line, it would be best to have an example of an anonymized file that you can attach from this link
https://www.cjoint.com/
--
A+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.