Total row max number in Excel
For example, the Table below lists the Quarter wise Sales data in the Year 2016 for all Salespersons in a Company. I would like to identify the Maximum Sales by a Salesperson in each Quarter.
To do it in Excel, here is the answer:
To add a Total Row that displays the maximum value in a column of numbers in a Table,
a) Click on any cell in the Table. In the Ribbon, "Table Tools" Design tab appears. Click on "Total Row" under "Table Style Options". "Total Row" appears at the end of the Table.
b) Click on cell in Total Row for the column for which Max value is to be determined. In the drop down, select Max. Repeat this step for the remaining 3 columns with Sales data.