+ Reply to Thread
Results 1 to 3 of 3

formula to auto delete number in dropdown list when number appears in another cell #2

  1. #1
    Registered User
    Join Date
    04-27-2014
    Location
    Kansas City
    MS-Off Ver
    Excel 2013
    Posts
    13

    formula to auto delete number in dropdown list when number appears in another cell #2

    hello everyone,

    I previously posted this title and now have another question on the same spreadsheet and labeled it as Solved. What is in the helper column works as I requested. The numbers 30, 27, & 14 in column K on the worksheet are deleted from the Helper Column as I like. The spreadsheet is about 300 rows.

    What I would like to do and keep getting errors in my efforts, so it isn't correct, is to use column P as a drop down list on every row. The drop down list will have numbers 1-40. As a number is entered in column K, it is deleted from the drop down list on every row.

    It might be more clear if I have a better explanation of the auto fill. In the Prefix column, under the g, enter "xe" and toggle right. You will see all column numbers change and the number 6 disappear from the Helper Column. Eventually the drop down list will become empty.

    Thank you and I appreciate any assistance anyone can be.

    ddevins

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,135

    Re: formula to auto delete number in dropdown list when number appears in another cell #2

    That concept is employed in this example. You will have to modify it for your purposes.

    http://blog.contextures.com/archives...ng-with-excel/
    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

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

    Re: formula to auto delete number in dropdown list when number appears in another cell #2

    here is one way
    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

+ 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. [SOLVED] formula to auto delete number in dropdown list when number appears in another cell
    By ddevins in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-28-2014, 04:54 AM
  2. Replies: 1
    Last Post: 07-18-2013, 10:11 AM
  3. Replies: 8
    Last Post: 04-22-2013, 06:30 PM
  4. Replies: 2
    Last Post: 12-06-2012, 05:52 PM
  5. Replies: 0
    Last Post: 08-28-2005, 10:37 AM

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