Results 1 to 7 of 7

Unique names list from data validation column

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-08-2013
    Location
    London
    MS-Off Ver
    365
    Posts
    138

    Unique names list from data validation column

    Hi there,

    I'm trying to find a formula to create a list of names not yet used in a column that has data validation. I've attached a sample file of what I am trying to achieve with two examples.

    The yellow highlighted list at the bottom of column I is what I am trying to create and is the list of names not yet used in the schedule above it (Range I3:I22).
    Column F is the list of names used for validation in column I and is made up of columns B (Staff) and D (Management).

    For the purpose of the schedule I only need to know which members of staff from column B have not been used on the schedule (yellow highlighted list at the bottom of column I). I have seen reducing validation lists that cut names out of the validation list as they are used but this will not work as I need to use names more than once on the schedule. I have tried to adapt some of these ideas but have spent hours getting nowhere.

    Any help in getting a formula or set of formulas to do this would be appreciated.

    Thanks in advance,
    Attached Files Attached Files
    Dave C

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unique list of records dropdown in Data Validation list
    By sghosh12 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2013, 08:27 AM
  2. Replies: 6
    Last Post: 07-08-2012, 03:54 PM
  3. Replies: 11
    Last Post: 10-06-2011, 02:26 PM
  4. Replies: 1
    Last Post: 10-05-2011, 04:57 PM
  5. Replies: 1
    Last Post: 07-08-2005, 11:05 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