Is "best" the same as "largest number"? If so, use the MAX function. Here is an example... if your values are in Column A, then...

=MAX(A2:A100)

will find the largest number in Column A between (and including) rows 2 and 100.

--
Rick (MVP - Excel)


"Michael Koerner" wrote in message ...
How would one pick out the best km/h from a column of numbers. example below

5.58
5.95
5.22

Where 5.95 is the best from the above list.

--

Regards
Michael Koerner