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" <(E-Mail Removed)> wrote in message news:eK%(E-Mail Removed)...
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.Columns("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" <(E-Mail Removed)> wrote in message news45EEEAC-FB0B-4090-BAF2-(E-Mail Removed)...
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.Columns("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" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
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" <(E-Mail Removed)> wrote in message news:eK%(E-Mail Removed)...
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