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?