Statistics - Statistics of Block Data - Block Columns/Rows - Max's

Ribbon bar: Select the Statistics tab. In the Tools group, click Block Data Stats and on the Block Columns submenu or the Block Rows submenu, select Max's to find the maximum value for each row or column in a selected block in the spreadsheet.

Classic menus: On either the Statistics - Statistics of Block Data - Block Columns submenu or the Statistics - Statistics of Block Data - Block Rows submenu, select Max's to find the maximum value for each row or column in a selected block in the spreadsheet.

The maximum values are found and displayed in a new spreadsheet as columns or rows. Selecting Statistics of Block Data - Block Columns displays the resulting statistic in a row and the case name includes the name of the selected statistic and the range description. Selecting Statistics of Block Data - Block Rows displays the resulting statistic in a column and the variable name contains the name of the selected statistic and the range description.

Note: You can also access this option by right-clicking on a selected block in the spreadsheet and selecting Statistics of Block Data - Block Columns/Rows - Max's from the Spreadsheet View shortcut menu.