By SCMAX 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
[…] Aggregate formula in excel used when cells in column contain value error or hidden rows as shown in image. Aggregate formula can be used for any formula max,min,sum,average. […]