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

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