I have a list of 20 or so proposals that requires 55 voting member to rank in
priority of importance with 1 being most important and 20 being least
important. Afterwards, all the rankings are added, and the one with the
lowest value has the highest priority.

How do I establish a "Rank" column to ensure that no 2 proposals have the
same ranking value AND that no proposal get a value greater than the max
number of proposal. That is, if there are 20 proposal, one of the proposals
does not get assigned a value of 21.

Please help. Any assistance is greatly appreciated.