+ Reply to Thread
Results 1 to 3 of 3

Employee Training Log Database

  1. #1
    Registered User
    Join Date
    11-17-2011
    Location
    Arkansas, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Employee Training Log Database

    I am in need of some help with a very cumbersome spreadsheet that is currently being used to track completed employee training. Here's how it's set up: each employee has their own tab -> listed on each tab is the description of their completed training (i.e. January 5 - Regulation D Webinar). I work at a bank and the regulators like to see a compilation of who attended each training session. Right now, the person in charge of compiling these training records is having to manually go in and look for "January 5 - Regulation D Webinar" in each person's tab.

    Here's my question: Is there a formula, or combination thereof, that will look in a specific range of cells for the "January 5 - Regulation D Webinar" text, and if it's found, return a value that is the employee name? I've tried various IF, MATCH, IFERROR, INDEX functions and have even tried to combine some to no avail. Any help would be much appreciated as I think I'm starting to go cross-eyed researching formulas! Thank you!

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Employee Training Log Database

    BeckyK,

    Welcome to the forum!
    It sounds like what you're looking for is the CountIf() formula. It would go something like this:
    =IF(COUNTIF('John Smith'!A1:A10,"January 5 - Regulation D Webinar")>0,"John Smith","")
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    11-17-2011
    Location
    Arkansas, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Employee Training Log Database

    That's not exactly what I was looking for but I was able to tweak my spreadsheet to make it work. Thank you so much for your help!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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