+ Reply to Thread
Results 1 to 6 of 6

Hide previously used item from list

  1. #1
    Registered User
    Join Date
    12-30-2018
    Location
    nottingham
    MS-Off Ver
    2016
    Posts
    2

    Hide previously used item from list

    Hi

    Ive created a list and table that allows me to only pick from a list once

    But this doesn't give me my solution. It does for say column D. But when i try and replicate this for Column E then i cant select the ones ive already selected in D. I want the list selections to be reflective of whats been selection in the column only not multiple columns.

    Hope that makes sense

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Hide previously used item from list

    Hi and welcome to the forum.

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-30-2018
    Location
    nottingham
    MS-Off Ver
    2016
    Posts
    2

    Re: Hide previously used item from list

    Quote Originally Posted by Richard Buttrey View Post
    Hi and welcome to the forum.

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Dont seem to have the rights to attach a spreadsheet

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Hide previously used item from list

    To attach a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Note that the paperclip icon does not work.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: Hide previously used item from list

    How many columns do you need to include?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Hide previously used item from list

    This sounds exactly like this thread including column specs.

    Formular to Calculate if a name has been used
    Last edited by FlameRetired; 01-12-2019 at 09:03 PM.
    Dave

+ 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. Data Validation Hide Previously Used Items in Dropdown
    By cheddarthief in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 07-10-2020, 10:57 PM
  2. Remove/Hide option from combobox list item
    By Gordon1985 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-17-2016, 09:57 AM
  3. PLease Help: Dropdown list that removes previously selected item
    By Gus88 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-01-2014, 01:28 PM
  4. [SOLVED] Hide/Unhide columns in multiple worksheets based on item chosen in a drop down list.
    By Gattaca2014 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-27-2014, 01:31 PM
  5. [SOLVED] List item hide
    By thameem127 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2012, 12:01 PM
  6. Data Validation hide previously used dropdown list
    By Fred Tan in forum Excel General
    Replies: 0
    Last Post: 10-01-2010, 07:44 AM
  7. Hide previously used items from multiple drop lists
    By ron in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-25-2006, 02:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1