AnsweredAssumed Answered

Ranking five fields

Question asked by DennisPrickett on Dec 15, 2010
Latest reply on Dec 17, 2010 by DennisPrickett


Ranking five fields


I have 5 fields, each of which carries a unique numerical value 1-100.  Each of the fields needs to be ranked on a 1 to 5 scale, where the field with the highest value is 1 and the field with the lowest value.  I can manually enter the ranking, but would rather have a calculation automatically perform the ranking as data is entered.

Suggestions on how to accomplish this?