Thread: Finding the biggest number out of 8 variables
View Single Post
  #12   Report Post  
Posted to microsoft.public.access,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Dennis Tucker Dennis Tucker is offline
external usenet poster
  
Posts: 140
Default Finding the biggest number out of 8 variables
=max(your cell range)

Dennis

"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


Reply With QuoteReply With Quote