Determine the best km/h

  • Thread starter Thread starter Michael Koerner
  • Start date Start date
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.
 
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.
 
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
 
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
 
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.
 
Back
Top