Hi
I have a number of fields where users can choose from option A to E, with A being the highest value. I need to find out what the highest value is that has been chosen out of any of these fields.
For example:
Field 1 value chosen B
Field 2 value chosen E
Field 3 value chosen A
The highest value is A, which is in field 3.
Field 1 value chosen C
Field 2 value chosen B
Field 3 value hosen D
The highest value is B, which is in field 2
Is it possible to get these fields into an array or set of value that I can sort and then pick the highest or something. Any help is highly appreciated .
Thanks