Excel: Find the highest value in a series of numbers

If you want to determine the highest value of a series of numbers in Excel, you can do this with a simple command. We'll show you how it's done.

Find the highest value of a series of numbers in Excel

1. Write down any series of numbers in Excel.
2. In the cell below, type "= MAX (" without the quotation marks.
3. Now you can mark the desired cells with the mouse. If you click Enter, the highest marked value is determined.
4. Alternatively, you can also write "= MAX (B1: B9)" in a cell without quotation marks, for example to determine the highest value in column B (see figure). You can define the cells using any number of rows and columns.

We explain other useful commands and functions in our other practical tips about Excel.