+ Reply to Thread
Results 1 to 6 of 6

Drop Down list with unique values, without blanks and without making a hidden column

  1. #1
    Forum Contributor
    Join Date
    10-20-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    108

    Drop Down list with unique values, without blanks and without making a hidden column

    Date of Birth 20/01/2016 20/01/2016 10/05/2014 15/06/2012 08/06/1999

    I need to create a Drop down list using dates of birth like those shown above.
    It needs to ignore blanks and remove duplicates to leave only unique values.
    Is it possible to do this without adding another row?

    The data will be extracted onto excel.
    It will then conceivably provide up to 20 dates of birth.
    The users are not excel literate, copy paste is the extent of their ability as civil servants.

    This is why I would like to provide a list for them based on the extracted data without hiding any cells as they will find a way to break it.

    I have provided a spreadsheet with the same details within this post for your convenience.

    Is this isn't possible, please let me know. Thanks.
    Attached Files Attached Files
    Last edited by eazy899; 10-21-2017 at 07:02 PM.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Drop Down list with unique values, without blanks and without making a hidden column

    No file attached

    To attach an Excel file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

  3. #3
    Forum Contributor
    Join Date
    10-20-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    108

    Re: Drop Down list with unique values, without blanks and without making a hidden column

    My bad, file is attached now.

    Thanks for letting me know.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Drop Down list with unique values, without blanks and without making a hidden column

    It will be a long wait for birth in 20162

  5. #5
    Forum Contributor
    Join Date
    10-20-2017
    Location
    London
    MS-Off Ver
    2016
    Posts
    108

    Re: Drop Down list with unique values, without blanks and without making a hidden column

    Ok so I guess this isn't possible then.

    Worth a try.

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Drop Down list with unique values, without blanks and without making a hidden column


+ 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. Replies: 3
    Last Post: 07-08-2014, 03:10 PM
  2. [SOLVED] Drop down list to allow only unique values in a column
    By Mzun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-25-2013, 03:07 AM
  3. [SOLVED] Drop-down list with hidden values
    By ExcelStefan in forum Excel General
    Replies: 4
    Last Post: 09-04-2012, 09:37 AM
  4. Replies: 7
    Last Post: 05-11-2012, 02:00 PM
  5. Replies: 3
    Last Post: 12-13-2011, 08:00 AM
  6. Making a list of unique items in a column
    By portsample in forum Excel General
    Replies: 6
    Last Post: 06-30-2011, 07:42 PM
  7. Making cell values correspond with Drop down List values
    By jrcream in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2008, 03:14 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