MAX,MIN,LARGE,SMALL Function in excel

MAX formula will return the maximum value present in row or column.

MIN formula will return the minimum values present in row or column.

To find minimum and maximum values we can use these formulas in excel.

If we have to find the second largest and second smallest numbers for that we can use SMALL and LARGE formula in excel.as shown below

MIN,MAX,SMALL& LARGE Formula in Excel

Click on above link to Listen