Using Lists for a User to Rank Items

Amnesiac

Board Regular
Joined
Apr 16, 2009
Messages
144
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!
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,214,875
Messages
6,122,042
Members
449,063
Latest member
ak94

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top