View original (French)

Excel formula

Jean-Mich592 Posted messages 2 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58226 Registration date   Status Contributor Last intervention   -

Hello,

I can't find the formula in Excel.

I have a column with three digits: 5, 1, 4.

And two cells for the result; the first cell should show the largest digit (5), the second cell the second largest (4);

Knowing that the input can be 1, 5, 4 or even 4, 5, 1.

I would like the largest digit to appear in cell 1 (e.g., 5) and the second in cell 2 (e.g., 4).

Thanks in advance for your responses

4 answers

  1.
    Raymond PENTIER Posted messages 58226 Registration date   Status Contributor Last intervention   17 488
     
    Hello Jean-Michel, and welcome to the new member!

    You must use the function GRANDE.VALEUR

    [image figure floated left: Grande_valeur.JPG]

    C'est bien, la retraite ! Surtout aux Antilles ...
    Raymond (INSA, AFPA)
    1
  2. Raymond PENTIER Posted messages 58226 Registration date   Status Contributor Last intervention   17 488
     

    Hello.

    Is your problem solved?

    That’s great, retirement! Especially in the Antilles...
    Raymond (INSA, AFPA)

    1
  3. DjiDji59430 Posted messages 4280 Registration date   Status Member Last intervention   718
     

    Bonjour à tous,

    “apparaisse le chiffre le plus grand” .

    Donc c'est celui qui a la plus grande valeur()

    Crdlmt

    0
  4. Grandasse_ Posted messages 981 Registration date   Status Member Last intervention   613
     

    Hello,

    > While knowing that the statement

    Here we don’t do others’ homework, sorry!

    -1
    1. Jean-Mich592 Posted messages 2 Registration date   Status Member Last intervention   1
       

      Hello Gandasse,

      I am 58 years old so the homework is ...

      Thanks anyway

      1
      1. DjiDji59430 Posted messages 4280 Registration date   Status Member Last intervention   718 > Jean-Mich592 Posted messages 2 Registration date   Status Member Last intervention  
         

        Not even conjugal??


        Sincerely

        0