Determine the best km/h

M

Michael Koerner

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.
 
R

Rick Rothstein

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)


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.
 
T

Tom Hutchins

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
 
M

Michael Koerner

It does, and thank you very much.

--

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
 
M

Michael Koerner

They are, and thank you very much.

--

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)


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.
 
Top