View original (French)

Google Sheets Sorting Automation

Solved
el -  
eloklm75 Posted messages 1 Status Member -
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 answers

  1.
    JCB40 Posted messages 3058 Registration date   Status Member Last intervention   479
     
    Hello
    See below
    https://www.extendoffice.com/documents/excel/5170-google-sheets-automatically-sort-alphabetically.html
    Best regards
    0
    1. 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
    2. 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
    3. el
       
      That the difference between the 2 columns be automatically sorted in the 3rd one.
      0