Results 1 to 6 of 6

Unique List From Row Name Based On Criteria from Column Data Header and Column Contents

Threaded View

jweatherford Unique List From Row Name... 12-05-2020, 12:00 AM
alansidman Re: Unique List From Row Name... 12-05-2020, 12:45 AM
avk Re: Unique List From Row Name... 12-05-2020, 12:48 AM
samba_ravi Re: Unique List From Row Name... 12-05-2020, 12:53 AM
jweatherford Re: Unique List From Row Name... 12-05-2020, 01:54 AM
alansidman Re: Unique List From Row Name... 12-05-2020, 10:19 AM
  1. #1
    Registered User
    Join Date
    12-04-2020
    Location
    Houston, Tx
    MS-Off Ver
    365
    Posts
    14

    Unique List From Row Name Based On Criteria from Column Data Header and Column Contents

    Hello,

    Hoping someone can help. I need to create a unique list of employees who will be working on specific dates. What I have is the list of employees in A2:A15, the list of dates in B1:N1. When the employee is scheduled to work that day, an "X" is placed in the cell corresponding with their name and the date.

    I need a formula that can be input into B20 and then copied down and over, that will generate the unique list of names that have an "X" next to their name in the given date in row 19. For example, B20 and down should read:

    Aaron Dotson
    Darris Lee
    Charles Matthews
    Jason Harris
    Alexander Sinegal
    Daniel Sepulveda

    I don't mean to be redundant, but basically, I just need a dynamic formula that will look at the date above itself in row 19, find that date in B1:N1, find where there's an "X" in that column, then return the name associated with it in A2:A15. I want it to create a unique list so that I can just copy the formula down and won't need to update the formula as employees come and go. Something like an INDEX MATCH INDEX COUNTIF. I don't want to use a pivot table or any VBA coding.. I've been trying to crack this thing all night but my brain is cooked.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 03-19-2020, 02:55 AM
  2. Unique drop down list of values based on criteria in other column(s)
    By SMP77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2019, 10:44 PM
  3. Extracting Unique List From Multiple Columns Based on Single-Column Criteria
    By Hellogiraffe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2019, 04:55 PM
  4. [SOLVED] VBA Creating a list of unique values from one column based on criteria from another column
    By bilbo85 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2016, 02:38 PM
  5. [SOLVED] Copy column data from multiple worksheets to single worksheet based on header criteria
    By nateaskins in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-21-2014, 10:42 AM
  6. Return column header based on column criteria and number value
    By bwill22 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2014, 07:33 PM
  7. [SOLVED] move contents of column C based on criteria related to column A
    By Debra in forum Excel General
    Replies: 2
    Last Post: 12-27-2005, 06:30 PM

Tags for this Thread

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