Training Log in Excel

Ray Flits 11 Reputation points
2021-01-11T21:25:30.17+00:00

Hey there,

I'm trying to set up a training log in excel, basically it will be a list of users, and the training they've taken.

There will be a scrollable list of users, when you click a user I want excel to display which training they've taken.

I've attached a crude screenshot which details what I'm trying to do, any help is appreciated!

55514-courses-test.png

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,725 questions
{count} vote

2 answers

Sort by: Most helpful
  1. Erin Ding-MSFT 4,461 Reputation points
    2021-01-12T08:40:21.45+00:00

    @Ray Flits

    Based on your description, it may require VBA code to realize.
    You could add a related tag like “office-vba-dev”, this may get more help.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

  2. Lz._ 9,006 Reputation points
    2021-01-15T13:13:14.103+00:00

    2 options with Excel 365 & Training data formatted as a table named Training (not mandatory, will work the same with a range)

    57183-demo.png

    in E8:
    =IF(ISBLANK(B8), "",
    SUBSTITUTE(
    TEXTJOIN(", ",TRUE,IF(INDEX(Training,MATCH(B8,Training[NAMES],0),0)<>0,Training[#Headers],"")),
    "NAMES, ",""
    )
    )

    in E9:
    =IF(ISBLANK(B8), "",
    SUBSTITUTE(
    TEXTJOIN(", ",TRUE,IF(FILTER(Training,Training[NAMES]=B8)<>0,Training[#Headers],"")),
    "NAMES, ",""
    )
    )

    Corresponding workbook available here

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.