Find out smallest and largest value in a range | Excel carols | Basic Excel
Merry Christmas 🎄
Excel Carols is back some of the very useful functions called the MIN MAX functions and it's variants.
MAX : Returns the largest value in a set of values.
MIN : Returns the smallest value in a set of values.
MAXIFS : Returns the largest value in a set of values, given there are conditions
MINIFS : Returns the smallest value in a set of values, given there are conditions.
Video link for AGGREGATE function : • Aggregate Function
Please like and share the video if you find it useful. Excel Carols is always looking for scope of improvements, so please mention your feedback in the comments section below. In case, you want to learn about any other feature of Ms Excel, please mention that too in the comments section. Don't forget to subscribe to the channel and press the bell icon in order to get all the notifications.
Please follow the instagram handle in order to get all the updates : https://instagram.com/excelcarols?utm...
#ExcelCarols #MsExcel #ExcelShortcuts #KeyboardShortcuts #ExcelOptions #MsExcelOptions