Excel Pro Trick: Hide used items in Drop down List - Remove Previously used items in Excel Dropdown

Learn how to create a dynamic drop down list in Excel that hides already used or selected items in Excel dropdown. This data validation list will remove previously used or selected item from the drop down list dynamically!
With a simple Excel formula, we can make this awesome Excel data validation drop down list that only let you select an item once! This way, users cannot use the same item twice from the drop down list.
In this step by step Excel tutorial, learn how to create data validation drop down lists that doesn't repeat selected items. As the already used or selected items are removed from the dropdown list.
Time to upgrade your data validation drop down menu in Excel!
Lets Excel!
Download Practice Workbook for this Excel Tutorial:
1drv.ms/x/s!Ap...
For more Excel tips, tricks and tutorials don't forget to subscribe to ‪@LearnExceltoexcel‬ channel.
Learn #Excel your way:
===================
Website: learnexceltoex...
--------------------------------------
Pick your favourite social page:
Fb: bit.ly/3yM3dvd
Tiktok: bit.ly/3wFllpf
Tw: bit.ly/3wGCRYU
Pin: bit.ly/3NsjKIU
Yt: bit.ly/3wxKL8a
Insta: bit.ly/3wtT9oW
Music by: / ikson
#dropdownlists #exceldatavalidation #datavalidation #dropdown #dropdownmenu #dropdownlist #exceltutorial #exceltips #dynamicdropdown #excel #dropdownnorepeat #dropdownhideuseditems

[@realvirtualdemand4222]

thanks for these tips, we need the description

[@LearnExceltoexcel]

Didn't get your question. Do you want a detailed tutorial on this topic?

[@suli976]

Very useful

[@LearnExceltoexcel]

Glad to hear that

[@justinsmith9878]

How did you get the conditional formatting to strike out the names used?

[@carloscrespo-riera9815]

Excellent! But you did not share the practice file link on the description.

[@LearnExceltoexcel]

Description updated with the link!

[@1minutetutorial1]

Still no link

[@LearnExceltoexcel]

@@1minutetutorial1 its in the description dear... here it is for you if you are having trouble finding it... onedrive.live.com/view.aspx?resid=8B2C6C3DCFEFE899!1987&ithint=file%2cxlsx&authkey=!AMgYBsqNWsvzHqQ

[@johnwillis1371]

This is great. it works perfect on a PC, but not on my mac even though i have excel 365. Any ideas on how to make this work with excel on a Mac?

[@deepanchakravarthy1116]

Super 👍🏻

[@LearnExceltoexcel]

Glad it helped :)

[@MD-os2vh]

can you please share the formula for strikethrough in the last column, because you did not describe it. Thanks!

[@jahmeheru]

👌🏾

[@atyuinnegi]

my version doesn't have filter formula...

[@LearnExceltoexcel]

Try Excel web. Its free and comes with FILTER function.

[@AMERUGUSumanth]

U Said the link is in description but it is not available

[@LearnExceltoexcel]

It's there dear...

[@LearnExceltoexcel]

Expand the whole description.

[@dimasagil90]

You miss the part when you want to reassign, the drop down shows no data XD

[@LearnExceltoexcel]

🤔 reassign? Where?

[@dimasagil90]

@@LearnExceltoexcel assuming you want to change the data after you fill all the cell.
You click the drop-down list and you get empty list.
You need to clear the data first so it shows up in drop down list

[@LearnExceltoexcel]

@@dimasagil90 Yes! that was the point of this list. Once all of the items are used, the list should become empty.
To change anything, you first need to "vacate" the person to "re-assign" :) just like real life 😃😃