By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-min-max/

Learn how to find the smallest and biggest numbers in a range using Excel's MIN and MAX functions. You'll learn how to insert these functions into cells quickly using the AutoSum feature, and how to find the minimum and maximum values on a single sheet and across a range of worksheets. You'll learn how to combine MIN and MAX with the XLOOKUP function to return related information, and how to use MIN and MAX in conditional formatting to highlight the biggest and smallest values in a list.

Chapters
00:00 Topic list
00:54 Basic MIN and MAX Functions
03:13 Using the AutoSum Feature
04:54 Creating Multiple MIN and MAX Functions
06:42 Using Multiple Ranges
08:50 Using Multiple Single Cells
10:08 MIN and MAX Functions in Group Mode
12:28 MIN and MAX Across a Range of Sheets
15:06 MIN and MAX with XLOOKUP
18:20 MIN and MAX in Conditional Formatting

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!