+ 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 Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    24,301

    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

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

    Forum Rules Updated September 2018. Please read them by clicking here.

  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 2010/2019
    Posts
    6,443

    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
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,567

    Re: Hide previously used item from list

    How many columns do you need to include?
    Glenn



  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    9,708

    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)

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