• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Attendance Spreadsheet

J

jcwq58

New Member
Hello,


My name is John and I manage a cusotmer service call center. I have an attendance workbook that compiles all the scheduled time off for each rep through a vlookup formula. Each rep has their own attendance spreadsheet and when another one of the assistant managers wants to see who is off that day they just look on the "master" sheet. I am trying to figure out a way that I can create a worksheet that tells me the names of the people out on any given day.


My master workbook has two tabs "Scheduled" and "Unscheduled". Here is basically how the master works:


1/1/12 1/2/12 1/3/12


John Doe 8.00

Jane Doe 8.00

Jim Doe 8.00

Jan Doe 8.00


I want to have a sheet that tells me that on 1/2/12 Jane and Jim are off. I want to be able to do this without having to look manually. Is this somethign that can be done?
 
Hi jcwq58,


You want a sheet based on master sheet that tells you who was off on a particular date?? What is 8.00 in the sample data in your last post?
 
Dear jcwq58,

your requirement is not clear to me. Would you kindly provide some sample data and indicate what kind of data will be returned.


Regards,

Muneer
 
I am going to attempt to load the sample. Thank you so much for your help!

The formatting of the example I showed did not hold (I should have known)
 
Here is the sample -


https://docs.google.com/spreadsheet/ccc?key=0Ar2ZMrkeOaO1dHpVTWd2eFVKOGVCNElnYjMtYk9JYUE#gid=0
 
Hi John ,


Please note that your file has not been properly shared ; anyone wanting to download the file will have to request permission from you.


Whenever you upload a file , and post the access link here , please first ensure that you have shared the file , and that anyone having the access link can download the file , otherwise , not everyone who wants to help will feel like requesting you for permission.


Narayan
 
You must log in or register to reply here.
Back
Top