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

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

If by "best" you mean highest, you could use a cell formula like one of these:
=MAX(A1:A3)
=MAX(A:A)

Using VBA, you could use something like:
Dim InRng As Range
Set InRng = Columns("A:A")
MsgBox Application.WorksheetFunction.Max(InRng)

or just:
MsgBox Application.WorksheetFunction.Max(ActiveSheet.Colu mns("A:A"))

Hope this helps,

Hutch

"Michael Koerner" wrote:

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

It does, and thank you very much.

--

Regards
Michael Koerner


"Tom Hutchins" wrote in message ...
If by "best" you mean highest, you could use a cell formula like one of these:
=MAX(A1:A3)
=MAX(A:A)

Using VBA, you could use something like:
Dim InRng As Range
Set InRng = Columns("A:A")
MsgBox Application.WorksheetFunction.Max(InRng)

or just:
MsgBox Application.WorksheetFunction.Max(ActiveSheet.Colu mns("A:A"))

Hope this helps,

Hutch

"Michael Koerner" wrote:

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

They are, and thank you very much.

--

Regards
Michael Koerner


"Rick Rothstein" wrote in message ...
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