Using the MOD Function to Minimize Leftovers . Let's say you have various items that you want to package and distribute.

The syntax for these functions are: =MIN(range); =MAX(range ... one condition must be true. For example, looking for an applicant with MS Word AND MS Excel experience means the applicant must ...

You will see a drop-down list of the functions ... formula (=MAX (C6:C15) into the cell and get the result. That’s it. Read: How to add or change the Theme for Workbook in Excel.

Excel's PIVOTBY function ... and PERCENTOF for the function argument in PIVOTBY, you can also use other aggregation functions, like COUNT, MIN, or MAX.

For example, there are several ways to enter formulas and calculate numbers in Excel. Use the Insert ... the matrix and enter this function for Maximum: =MAX(E33:E37) or this for the Minimum ...

The real power here is that you can substitute MAX() with just about any Excel function. For example, Figure B shows the sum of columns D and E. I changed the array reference from [Date ...

If you would like to follow along in using this function, you can download this Excel workbook and view the video at the end of this article. Let’s work on a few examples using the GROUPBY function.