How to find largest number using Max Function in Google Spreadsheet?
In Google docs spreadsheet, find the maximum or largest value in the worksheet using MAX().
Step 1: Select Max function using any of the following three options.
Option 1: Click Insert → Function → MAX
Option 2: Click the arrow near Summation icon and select "MAX".
Option 3: Type "=max(", select the cell, type ":" and select the another cell and then type ")"
Step 2: Click and drag the cells to add the cell range.
Step 3: Press Enter button to find the result.