I have ten items in a list in column A. I want a user to be able to give each of these items a score or ranking 1 through 10, so two items can't have the same score. There will be drop down lists in column b. In cell B1, next to the first item, there will be a drop down list with 10 choices 1 through 10. In cell b2, next to the second item, there will be a drop down list but if the number 6 were selected in the first drop down list the user would only be allowed to pick 1,2,3,4,5,7,8,9,10. And so on until the last selection would be whichever number was left over. Make sense? Any ideas on how to accomplish this?
Thanks!
Thanks!