View Single Post
  #2   Report Post  
Posted to microsoft.public.access,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
GeoffG GeoffG is offline
external usenet poster
 
Posts: 2
Default Finding the biggest number out of 8 variables

There are many solutions.

You could put the values into an array and pass the array to
a QuickSort routine.

The QuickSort algorithm is difficult to understand, but you
really don't need to know how it works. See:

http://vbnet.mvps.org/index.html?cod...qsoverview.htm


Geoff




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