Excel worksheet: [closed]

-1

What is the formula for finding the smallest number, second, third, fourth, etc.

Numero  
300 Menor numero
300 2º  Menor (Qual é a Formula)
297 3º  Menor
297 4º  Menor
62  5º  Menor
62  6º  Menor
62  
44  
44  
23  
23  
23  
23  
19  
19
    
asked by anonymous 15.03.2016 / 23:49

1 answer

1

Within excel you can use the function = MINOR (matrix, k). Where array is the area where the numbers are, and k the position you want, 1 - first, 2 - second ...

    
16.03.2016 / 00:05