+ Reply to Thread
Results 1 to 7 of 7

Deleting Name When Selected from a Drop Down List

  1. #1
    Registered User
    Join Date
    08-20-2013
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    12

    Deleting Name When Selected from a Drop Down List

    Hello,



    I have been tirelessly working on trying to make a simple program on Excel. I have a list of people in column A, inputted as a text. On the same worksheet I have a drop down list with the same names available for selection. Drop down lists are C10, C11, C21 and C22. I would like the names in column A to disappear when they are selected from any drop down list. I have included a picture to better articulate my problem.

    I managed some semblance of success by entering the following formula in to A6: =IF(C10="Allen", " ", "Allen"). This only works if Allen's name is chosen from the drop down list at C10, but not other drop down lists. Can anybody offer some advice on this problem?

    Excel_Pic2.jpg

  2. #2
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Deleting Name When Selected from a Drop Down List

    Is it OK that the name reappears when you select another name in the dropdown list? Because that's what's happening in your formula.
    If you want them permanently removed, you need to build a macro.

    If you just want the other dropdown lists added to your original formula, use the OR function:
    =IF(OR(C10="Allen",C11="Allen",C21="Allen",C22="Allen"), " ", "Allen")
    When I say semicolon, u say comma!

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Deleting Name When Selected from a Drop Down List

    Perhaps something like this:

    http://www.contextures.com/xlDataVal03.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    08-20-2013
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Deleting Name When Selected from a Drop Down List

    L-Drr and alansidman, thank you so much for being extremely helpful and supportive. Your feedback has been immensely instructive.

    With respect to your question L-Drr, yes, it is okay that the name reappears when you select another person; that's exactly what I want it to do.

    alansidman, that wasn't my original intention (i.e. to remove them from the names from the list), but upon further reflection it sounds like an ingenious idea.

  5. #5
    Registered User
    Join Date
    08-20-2013
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Deleting Name When Selected from a Drop Down List

    L-Drr so far so good. Thanks again for the help.
    Last edited by Grabaka; 08-20-2013 at 09:29 AM.

  6. #6
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Deleting Name When Selected from a Drop Down List

    i prefer this method
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  7. #7
    Registered User
    Join Date
    08-20-2013
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Deleting Name When Selected from a Drop Down List

    Thank you for this alternative method. I must admit it is a bit beyond my capabilities, but it will give me a lot to learn by dissecting it. Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Drop down list that changes selected sheet
    By Mike_StGeorge in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 06-22-2017, 01:39 PM
  2. Selected Drop Down List value not updating.
    By pete87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2012, 11:12 AM
  3. [SOLVED] Sum The Values As per the Selected in Drop Down List
    By get2mandar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-11-2012, 03:09 AM
  4. Drop down list with pre selected value.
    By nukecity83 in forum Excel General
    Replies: 9
    Last Post: 08-31-2009, 03:03 AM
  5. Value selected on drop down list, look-up on different sheet
    By liseladele in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2006, 10:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1