Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Several worksheet tally by name
I have a worksheet that has several layers:
Tardy, Absent, Jan, Feb, Mar, Apr etc., etc. I have the employees listed on the first two with a reference of their initials: Smith, Robert (RS) On each of the individual months I have noted (RS) for each day absent or tardy, separating each employee if more than one are tardy on any given day by a comma: (RS), (PG) etc., etc. I can't seem to figure out how to keep a running tally of tardy and absent? Thanks in advance! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Several worksheet tally by name
So long as you use that structure you'll have nothing but heartache and errors
Just use one column for the date (not the month), another column for the employee, and a 3d column for T(ardy) or A(bsent) If more than one is absent or tardy on the same date, put the date in as many times as needed for each event. In other words, if 3 are absent/tardy on May 12, enter May 12 three times, once for each employee Then you can create Pivot tables or use simple formulas for what you want. "TiaB" wrote: I have a worksheet that has several layers: Tardy, Absent, Jan, Feb, Mar, Apr etc., etc. I have the employees listed on the first two with a reference of their initials: Smith, Robert (RS) On each of the individual months I have noted (RS) for each day absent or tardy, separating each employee if more than one are tardy on any given day by a comma: (RS), (PG) etc., etc. I can't seem to figure out how to keep a running tally of tardy and absent? Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Tally marks in an excel worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |