Finding the biggest number out of 8 variables

  • Thread starter Thread starter Mojo
  • Start date Start date
M

Mojo

Hi All

Does anybody know of an easy way to find out which variable has the highest
value out of 8 variables?

For example, I have these values in 8 vars:

3 0 7 30 37 17 0 7

Although from a human's perspective it's easy to see that the 5th var has
the highest value, how can I chose the appriopriate var programmatically?

Thanks
 
You asked this same question over in one of the compiled VB newsgroups; so,
because this is an Excel newsgroup, I think you need to clarify something
for us. Are you working in Excel? If so, is your question a VBA question? If
so, what are your variable's names? Or do you mean "variables" in a more
general sense, that being cells on a worksheet? I ask this last question
because if you have your posted values in a worksheet, say in cells A1, B1,
through to H1, then you could use the worksheet's MAX function to get your
value... =MAX(A1:H1) for my assumed cells A1 through H1.
 
Hi Mojo,

Try the following:

Sub GetMaxValue()

Dim Vals(1 To 8) As Integer

Vals(1) = 50
Vals(2) = 20
Vals(3) = 80
Vals(4) = 10
Vals(5) = 90
Vals(6) = 70
Vals(7) = 30
Vals(8) = 40

MsgBox Application.Max(Vals)

End Sub
 
does this do what you want?
=MAX(A1:H1)
this will return the highest value in the range

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
I don't think so.

Damon

Howard31 said:
Hi Mojo,

Try the following:

Sub GetMaxValue()

Dim Vals(1 To 8) As Integer

Vals(1) = 50
Vals(2) = 20
Vals(3) = 80
Vals(4) = 10
Vals(5) = 90
Vals(6) = 70
Vals(7) = 30
Vals(8) = 40

MsgBox Application.Max(Vals)

End Sub
Click to expand...
 
Try something like the following air code.

Sub Test()
Highest(Val1, Val2, Val3, Val4, Val5, Val6, Val7,Val8)
End Sub

Function Highest(Var1,Var2,Var3,Var4,Var5,Var6,Var7,Var8)
Highest = Var1
If Var2 > Highest then Highest = Var2
If Var3 > Highest then Highest = Var3
If Var4 > Highest then Highest = Var4
If Var5 > Highest then Highest = Var5
If Var6 > Highest then Highest = Var6
If Var7 > Highest then Highest = Var7
If Var8 > Highest then Highest = Var8
End Function

Regards

Kevin
 
Function Highest(Var1,Var2,Var3,Var4,Var5,Var6,Var7,Var8)

Hi. For this approach, here's a way to have an unspecified number of
inputs:

Function Highest(ParamArray v())
Highest = WorksheetFunction.Max(v)
End Function

Sub TestIt()
Dim x
x = Highest(12, 15, 9, 5)
MsgBox x
End Sub

= = =
Dana DeLouis
 
If you don't make it more clear what you want to do, no one can answer
your question appropriately. Do you want to know the highest value among
some valuables or want to know the variable's name which has the highest
value among some valuables? if what you want is the latter, i think
there is no easy way to know the variable's name or i wonder there is
such a way to know the name. i mean variable's name, not the address of
the variable.

Keiji
 
Back
Top