+ Reply to Thread
Results 1 to 4 of 4

Need to match managers to certain codes

  1. #1
    Registered User
    Join Date
    01-10-2019
    Location
    Copenhagen
    MS-Off Ver
    2016
    Posts
    5

    Question Need to match managers to certain codes

    I have two tables 1 & 2:
    Table 1 shows certain company codes, with date, time, code name, etc.. Table 1 can easily have several codes happening the same day.
    Table 2 shows managers on duty, with date, shift type (morning, evening or night), employee number, and name. Table 2 has around 20 different managers at work each day.
    I have been asked to find out what managers work when X company code is happening. See the two example tables below:

    Table1+2.jpg

    What I originally thought of, was to match the dates, shifttype, and then if they do, lookup the manager. Maybe by creating a row for each managertype, but I don't know how to match it so it works. Any thoughts would be highly appreciated!

    The two tables shown here are just examples and represent tables that are a lot bigger (Table 1: A-AG columns with some 20000 rows, Table 2 A-F columns with 25000 rows).

    Thanks in advance!

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Need to match managers to certain codes

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    01-10-2019
    Location
    Copenhagen
    MS-Off Ver
    2016
    Posts
    5

    Re: Need to match managers to certain codes

    Hi again, I think I have added the file now. I hope it makes sense, found it harder to explain than I thought it would be.
    Kind regards
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-10-2019
    Location
    Copenhagen
    MS-Off Ver
    2016
    Posts
    5

    Re: Need to match managers to certain codes

    I managed to solve this question by creating a helper column that concatenates the date, shift type, and manager to create a unique value that I could make a Vlookup function upon, by adding a column for each manager with the manager name in the table heading.
    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Filtering a project managers tabs
    By NTE-Todd in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-30-2015, 03:47 AM
  2. Hotel Revenue Managers
    By mdt175 in forum Excel General
    Replies: 1
    Last Post: 10-11-2014, 01:34 PM
  3. Emailling PDFs to users and managers
    By Sibrulotte in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 01:29 PM
  4. [SOLVED] Recursive find of managers
    By flyboy54 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-22-2013, 11:32 AM
  5. Summarizing Data for Managers
    By VBA Beginner in forum Excel General
    Replies: 3
    Last Post: 02-13-2007, 02:34 PM
  6. Putting Managers underneath areas
    By SunnyM in forum Excel General
    Replies: 1
    Last Post: 12-07-2006, 01:05 PM
  7. Sell Program - Screwed by Managers !!!
    By Greg Wilson in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-12-2006, 11: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