Results 1 to 4 of 4

Return list of competent skills by username

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-29-2009
    Location
    sheffield
    MS-Off Ver
    Excel 2013
    Posts
    210

    Return list of competent skills by username

    On the attached, my data is in A1:D11

    I want to be able to select a username in G1 and corresponding skills from A1:D11 that are marked with a Y for that user, then list below the user name in column G.

    The attachment shows the desired results for user Joe Bloggs.
    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. Function to return and input an email address from username/details?
    By ZEROCOOL UK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2019, 11:28 AM
  2. Environ$ does not return the Username
    By Lexian in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-16-2018, 02:54 AM
  3. vlookup and condition? matching employee's skills and Ticket skills
    By yannc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2014, 03:27 PM
  4. Dangerously Competent
    By BAM475294 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-27-2013, 01:40 PM
  5. [SOLVED] work list connected with holiday plan and skills table
    By young_86 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-24-2013, 04:24 AM
  6. Looking to shake the dust of my Excel skills and old Algebra skills using Excel
    By twolittlehorses4me in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 11-21-2012, 07:05 AM
  7. Randomly dispatch list of employee in three groups according to skills
    By nikenis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2012, 03:57 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