+ Reply to Thread
Results 1 to 6 of 6

Hide Used Items in Drop Down List

  1. 06-17-2023, 08:41 AM #1
    Ramesh h&m
    Ramesh h&m is offline
    Forum Contributor
    Join Date
    03-28-2016
    Location
    india
    MS-Off Ver
    2013 (in 2023)
    Posts
    134

    Hide Used Items in Drop Down List

    Hi Gd evening..

    I have tried to Hide the Used Items in Drop Down List. But its not working properly and i don't know where i have done the mistake. Pls help me identify.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-17-2023, 09:53 AM #2
    Marius44
    Marius44 is offline
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    182

    Re: Hide Used Items in Drop Down List

    HI
    The formula in column H must NOT be a "single" matrix but must include the WHOLE list.
    HI,
    Mario
    Attached Files Attached Files
    Last edited by Marius44; 06-17-2023 at 09:57 AM.
    Reply With QuoteRegister To Reply
  3. 06-17-2023, 10:31 AM #3
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Hide Used Items in Drop Down List

    Helper column K ids used.
    In K1 copied down till blank cell is seen.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Select range for DV (Say E2:E12). Formula for DV is
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by kvsrinivasamurthy; 06-17-2023 at 10:41 AM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  4. 06-17-2023, 11:17 AM #4
    Ramesh h&m
    Ramesh h&m is offline
    Forum Contributor
    Join Date
    03-28-2016
    Location
    india
    MS-Off Ver
    2013 (in 2023)
    Posts
    134

    Re: Hide Used Items in Drop Down List

    Quote Originally Posted by Marius44 View Post
    HI
    The formula in column H must NOT be a "single" matrix but must include the WHOLE list.
    HI,
    Mario
    Thank you marius... But i am not understanding about, " "single" matrix"
    Reply With QuoteRegister To Reply
  5. 06-17-2023, 11:19 AM #5
    Ramesh h&m
    Ramesh h&m is offline
    Forum Contributor
    Join Date
    03-28-2016
    Location
    india
    MS-Off Ver
    2013 (in 2023)
    Posts
    134

    Re: Hide Used Items in Drop Down List

    Quote Originally Posted by kvsrinivasamurthy View Post
    Helper column K ids used.
    In K1 copied down till blank cell is seen.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Select range for DV (Say E2:E12). Formula for DV is
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Thank you kvsrinivasamurthy sir...
    I am also from india. Nice to see you here...
    I am really appreciate your involvement...
    Reply With QuoteRegister To Reply
  6. 06-18-2023, 01:17 AM #6
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Hide Used Items in Drop Down List

    Pl mark the thread solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hide Used Items in Drop Down List across multiple sheets
    By Matthew2 in forum Excel General
    Replies: 10
    Last Post: 01-19-2024, 12:39 AM
  2. Hide Tabs Based on the choice of Multiple Items from Drop Down List
    By knopp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-21-2021, 03:12 PM
  3. Hide used items from drop down list. (base ball teams selection for multiple innings)
    By Sridhar Kollepara in forum Excel General
    Replies: 0
    Last Post: 07-12-2020, 02:18 AM
  4. Hide Used Items in Drop Down List
    By fffleague15 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-05-2015, 12:10 PM
  5. Hide used items in drop down list & select multiple items in a drop down list
    By philip.michael.smith in forum Excel General
    Replies: 0
    Last Post: 04-22-2014, 11:03 PM
  6. Hide previously used items from multiple drop lists
    By ron in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-27-2006, 05:20 PM
  7. Hide previously used items from multiple drop lists
    By ron in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2006, 02:45 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1