Drop-down menus in tables and removing used items from that menu

ctroxtell

New Member
Joined
Jan 14, 2015
Messages
11
Office Version
  1. 365
  2. 2016
Hey guys, I'm hoping someone can help get me on the right track. I'm working on an Excel sheet that has 100+ addresses on it with employees on the sheet. I'm trying to make it so the drop-down menu will only allow the list item to be selected one time. The sheet has 10 tables, 1 for each staff member with a column in a table labeled Address, then I've created a table that holds my entire list of addresses. How can I hide the addresses that have already been selected from the drop down menu? Currently using Excel 365, I was experimenting and had got it partially working with COUNTIF but it wouldn't translate when I selected the entire address column
 
Thanks for the detail.
You can turn that warning off in File -> Options -> Formulas -> Error checking rules -> Uncheck 'Data entered in a table is invalid' -> OK

1729819048711.png
 
Upvote 1

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
@ctroxtell
Post #11 is clearly not a solution to the thread question so I have moved the 'Mark as solution' from that one to post #7. The mark should be used to indicate the actual solution post to help future readers quickly locate the solution if they have a similar question.
 
Upvote 0

Forum statistics

Threads
1,224,595
Messages
6,179,798
Members
452,943
Latest member
Newbie4296

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