View Single Post
  #3   Report Post  
Old July 2nd 21, 08:35 AM
Wilbur Chua Wilbur Chua is offline
Member
 
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default Large and Max

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!