Tutorial de Excel que explica cómo obtener los valores máximo y mínimo de un rango así como el segundo y sucesivos valores máximos y mínimos de un rango. Función MAX, MIN, K.ESIMO.MAYOR, K.ESIMO.MENOR. Máximo y mínimo en Excel.
00:00Hello everyone, in this video we will see how to find the maximum and minimum value of a range of
00:09cells. In this case, for the example, we have the average temperature, maximum temperature and
00:15minimum temperature values for the month of February. And what we want to find is the absolute
00:21maximum temperature of the month, that is, the highest in the maximum temperature.
00:30So, we go to the cell where we want the result, right equals max and then select the range of cells from
00:35which we want to obtain the maximum. We select the range of cells in which the maximum temperatures
00:43are found, press enter and we see that it gives us the result of 16.18. If we look at the values,
00:51we see that the last day of the month was indeed the maximum temperature, 16.18.
01:00Let's see the same example, but this time with the minimum temperature, that is, the absolute minimum
01:05of all the cells we have. We write equals min and select the range from which we want to obtain the
01:13minimum value. We select the range of minimum temperatures, press enter and we see that it
01:20gives us a value of minus 6.24. And if we look in the cells, we see that minus 6.24 is the minimum temperature
01:31that occurred on February 19th. It may also be that what we need is not to obtain the first maximum
01:37temperature, but the second, third or successive maximum temperatures.
01:40So, let's see what function we would have to use in that case, for example, to obtain the second maximum
01:51temperature of the month, we write equals k and we see that two functions appear, k major and k
01:56minor. In this case, since we want the second highest temperature, we choose the first one, double click,
02:06go to the function and the first thing we have to select is the matrix.
02:12In this case, we would select the cells where the maximum temperatures are.
02:19And in the second case, in k, it indicates the position of the value that we want it to return.
02:25As we can see below, it represents within the matrix or data range the position from the highest value
02:30of the data to return. Since what we want is the second highest temperature, we write a 2,
02:36so, press accept and it gives us a value of 15.24.
02:42If we look within the maximum temperatures, we see that we are on the 15th, 15.24.
02:50Let's imagine that what we want is the third maximum temperature of the month.
02:55Let's write in this cell. Let's change the 2 here and write a 3.
02:59We see that it gives us 15.24 again. This is because this temperature repeats on 2 days.
03:06The first time it appears is on the 15th and the second time it appears is on the 26th,
03:11so both the second and third maximum temperatures would be 15.24.
03:20Let's stay at 2 again and do the same operation for the second minimum temperature of the month.
03:25We write the same K and this time we choose K minor.
03:37First we choose the function, the matrix, that is, all the cells that contain the minimum temperatures and again the position.
03:43In this case, we want the second lowest temperature of the month, so we type a 2, press accept, and we see that it gives us a result of minus 5.9.
03:53If we look at all the minimum temperatures, we see that the value of minus 5.9 occurs on the fifth.
04:05And using these two functions, we can obtain, in an ordered manner, the maximum and minimum values of a range of cells.
Sé la primera persona en añadir un comentario