• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to make drop down list except the selected name in the particular cell

Kutty

Member
Hai Excel Experts!
How to make drop down list in many rows except the selected name in the previous cells. I attached herewith my excel file for your reference.
Thanks.
by Kutty
 

Attachments

  • Test file.xlsx
    11.7 KB · Views: 2
Last edited:
We can use formulas to build a new list that doesn't include selected items. I also built your dynamic validation as wlel.
 

Attachments

  • Test file LM.xlsx
    12.5 KB · Views: 11
Back
Top