Hello!
we can use the LARGE Function or the
MAX Function in excel.
MAX function identifies the largest number in a given array, while LARGE Function identifies the largest, 2nd largest, etc depending on what you requested.
So MAX Function goes:
=Max(number 1, number 2....) or an array
For Large Function, it goes:
=Large(array,k)
the K here is where you indicate if you want the largest number, by putting in 1, 2nd largest number by putting in 2, so on and so forth.
The MAX function is used in situations with more than 1 column, vs the LARGE function that focuses on 1 column, but with more options.
Hope this helps!