Results 1 to 10 of 10

Determine List of People at Each Location on Each Day

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Newfoundland
    MS-Off Ver
    Excel 2010
    Posts
    21

    Determine List of People at Each Location on Each Day

    Spreadsheet is attached.

    I have a list of 3 people (Tom, **** and Harry).

    I have 3 possible sites for each of them to be on any particular day (Site1, Site2 and Site3).

    So, I have a worksheet set up with a row for each day of the year; then 3 columns for Tom, **** and Harry. For each day, I put in which site they are working at. What I want to do is have 3 subsequent worksheets for each site.

    In the Site1 worksheet, I would have 3 columns (Person 1, Person 2, Person 3) and a row for each day of the year. What I'd like to do is have a formula to look in the main worksheet (titled "Calendar" in the attached spreadsheet) and for each day, look to see who is listed for each site and place them in the Person 1, Person 2, and Person 3 columns, if applicable. In the attached spreadsheet, I manually put the names into the Site1, Site2 and Site3 worksheets, but I'm hoping there is a way to get this with a formula.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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