Spreadsheet of excel:

Asked

Viewed 43 times

-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
  • I did not understand your question, which shows the results on the screen of a program is this?

1 answer

1

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

Browser other questions tagged

You are not signed in. Login or sign up in order to post.