View original (French)

Google Sheets Sorting Automation

Solved
el -  
eloklm75 Posted messages 1 Status Membre -
Hello,

I am trying to create an automatic sort of values in ascending or descending order on Google Sheets but I can't manage it, except manually using the classic sort A-Z.

For example, in column B from B3:13, I enter random values and I would like them to be automatically sorted in ascending/descending order once these values are entered.

How can I do this, please?

Thank you in advance for your reply.

2 réponses

Réponse 1 / 2
JCB40 Posted messages 3053 Registration date   Status Membre Last intervention   479
 
Hello
See below
https://www.extendoffice.com/documents/excel/5170-google-sheets-automatically-sort-alphabetically.html
Best regards
0
el
 
Hello,

Thank you for your response, it works, but to go further, how can I make it so that it is in the same column? Let me explain, the values are sorted but in an adjacent column; I would like them to be sorted in the original column please.

Thank you in advance for your response.
0
el
 
I have a column D and a column E with 10 values underneath each one
I have a third column that is the difference of E-D and it is this third column that I would like to be directly sorted in ascending order
I tried =sort(E18-D18, 1, true) but it didn't work
0
el
 
That the difference between the 2 columns be automatically sorted in the 3rd one.
0