Min, Max, Median Formula in Excel
Link to full course: https://commercecurve.com/ultimate-ex...
Take this course if you're looking for a complete course with end-to-end Excel training to accelerate your career.
You can use MIN and MAX formula to determine the smallest and largest values in a field based on the specified aggregation or grouping. The MEDIAN is the number in the middle of a set of numbers.
=MAX(number1, [number2], ...)
=MIN(number1, [number2], ...)
=MEDIAN(number1, [number2], ...)
Number1… (required): Number range in which you want to find the maximum, minimum or median value.