Spreadsheet: 98995d1297790597-creating-a-calendar-with-auto-update-functions-findtheemployee
Sheet: INDEX-Personnel

Name | ID | Level | Location | Date | Month | Day
[NAME] | 1 |  | Top |  |  |  |  |  | Pivot Table Example from Data |  |  |  |  |  |  |  |  | Advanced Filter Example from Data
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top |  |  |  |  |  | Name | [NAME] |  |  |  |  |  |  |  | Name | ID | Level | Location | Date | Month | Day
[NAME] | 2 |  | Bottom |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | 1 |  | Top |  |  |  |  |  | Count of Name | Month
Fred | 3 |  | Top |  |  |  |  |  | Day | 2 | 3 | 4 | 7 | 5 | 8 | 6 |  | Name | ID | Level | Location | Date | Month | Day
[NAME] | 1 |  | Bottom |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-02-16 00:00:00 | 2 | 16
[NAME] | 1 |  | Top |  |  |  |  |  | Bottom |  |  | 1 | 1 |  |  |  |  | [NAME] | 1 |  | Top | 2011-02-23 00:00:00 | 2 | 23
[NAME] | 2 |  | Bottom |  |  |  |  |  | Top |  |  |  |  |  | 2 | 1 |  | [NAME] | 1 |  | Top | 2011-03-02 00:00:00 | 3 | 2
[NAME] | 1 |  | Top |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-03-02 00:00:00 | 3 | 2
[NAME] | 2 |  | Bottom |  |  |  |  |  | Bottom |  | 1 | 1 |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-03-09 00:00:00 | 3 | 9
[NAME] | 1 |  | Top |  |  |  |  |  | Top |  |  | 1 |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-03-12 00:00:00 | 3 | 12
[NAME] | 2 |  | Bottom |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-03-13 00:00:00 | 3 | 13
[NAME] | 1 |  | Top |  |  |  |  |  | Bottom |  |  |  | 1 |  |  |  |  | [NAME] | 1 |  | Top | 2011-03-19 00:00:00 | 3 | 19
Fred | 3 |  | Top |  |  |  |  |  | Top |  |  |  |  |  | 1 |  |  | [NAME] | 1 |  | Top | 2011-03-20 00:00:00 | 3 | 20
[NAME] | 1 |  | Bottom |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-03-26 00:00:00 | 3 | 26
[NAME] | 1 |  | Top |  |  |  |  |  | Bottom |  |  | 1 |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-03-27 00:00:00 | 3 | 27
[NAME] | 2 |  | Bottom |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-03-30 00:00:00 | 3 | 30
[NAME] | 1 |  | Top |  |  |  |  |  | Bottom |  |  | 1 |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-04-01 00:00:00 | 4 | 1
[NAME] | 2 |  | Bottom |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-04-02 00:00:00 | 4 | 2
[NAME] | 1 |  | Top |  |  |  |  |  | Top |  |  |  |  |  | 2 |  |  | [NAME] | 1 |  | Top | 2011-04-04 00:00:00 | 4 | 4
[NAME] | 2 |  | Bottom |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-04-08 00:00:00 | 4 | 8
[NAME] | 1 |  | Top |  |  |  |  |  | Top |  |  |  |  |  |  | 1 |  | [NAME] | 1 |  | Bottom | 2011-04-16 00:00:00 | 4 | 16
Fred | 3 |  | Top |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-04-16 00:00:00 | 4 | 16
[NAME] | 1 |  | Bottom |  |  |  |  |  | Bottom |  |  |  |  |  | 1 |  |  | [NAME] | 1 |  | Bottom | 2011-04-16 00:00:00 | 4 | 16
[NAME] | 1 |  | Top |  |  |  |  |  | Top |  | 2 |  | 1 | 1 | 1 | 1 |  | [NAME] | 1 |  | Top | 2011-04-20 00:00:00 | 4 | 20
[NAME] | 2 |  | Bottom |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-04-23 00:00:00 | 4 | 23
[NAME] | 1 |  | Top |  |  |  |  |  | Bottom |  |  |  |  | 1 |  |  |  | [NAME] | 1 |  | Top | 2011-05-02 00:00:00 | 5 | 2
[NAME] | 2 |  | Bottom |  |  |  |  |  | Top |  |  |  |  | 1 |  |  |  | [NAME] | 1 |  | Top | 2011-05-06 00:00:00 | 5 | 6
[NAME] | 1 |  | Top |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-05-07 00:00:00 | 5 | 7
[NAME] | 2 |  | Bottom |  |  |  |  |  | Bottom |  |  |  | 1 |  |  | 1 |  | [NAME] | 1 |  | Bottom | 2011-05-07 00:00:00 | 5 | 7
[NAME] | 1 |  | Top |  |  |  |  |  | Top |  |  |  |  | 1 | 3 |  |  | [NAME] | 1 |  | Top | 2011-05-09 00:00:00 | 5 | 9
Fred | 3 |  | Top |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-05-11 00:00:00 | 5 | 11
[NAME] | 1 |  | Bottom |  |  |  |  |  | Top |  |  |  |  | 1 |  |  |  | [NAME] | 1 |  | Bottom | 2011-05-11 00:00:00 | 5 | 11
[NAME] | 1 |  | Top |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-05-21 00:00:00 | 5 | 21
[NAME] | 2 |  | Bottom |  |  |  |  |  | Top |  |  |  | 2 | 1 |  | 1 |  | [NAME] | 1 |  | Top | 2011-05-22 00:00:00 | 5 | 22
[NAME] | 1 |  | Top |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-05-23 00:00:00 | 5 | 23
[NAME] | 2 |  | Bottom |  |  |  |  |  | Top |  |  |  |  | 1 | 1 |  |  | [NAME] | 1 |  | Top | 2011-05-23 00:00:00 | 5 | 23
[NAME] | 1 |  | Top |  |  |  |  |  | 17 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-05-31 00:00:00 | 5 | 31
[NAME] | 2 |  | Bottom |  |  |  |  |  | Top |  |  |  |  | 1 | 1 | 1 |  | [NAME] | 1 |  | Top | 2011-06-03 00:00:00 | 6 | 3
[NAME] | 1 |  | Top |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-06-07 00:00:00 | 6 | 7
Fred | 3 |  | Top |  |  |  |  |  | Top | 1 |  |  |  |  |  | 1 |  | [NAME] | 1 |  | Top | 2011-06-07 00:00:00 | 6 | 7
[NAME] | 1 |  | Bottom |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-06-10 00:00:00 | 6 | 10
[NAME] | 1 |  | Top |  |  |  |  |  | Bottom |  |  |  | 1 |  |  |  |  | [NAME] | 1 |  | Top | 2011-06-11 00:00:00 | 6 | 11
[NAME] | 2 |  | Bottom |  |  |  |  |  | Top | 1 | 1 | 1 |  |  | 1 |  |  | [NAME] | 1 |  | Top | 2011-06-15 00:00:00 | 6 | 15
[NAME] | 1 |  | Top |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-06-16 00:00:00 | 6 | 16
[NAME] | 2 |  | Bottom |  |  |  |  |  | Bottom |  |  |  |  |  | 1 |  |  | [NAME] | 1 |  | Top | 2011-06-17 00:00:00 | 6 | 17
[NAME] | 1 |  | Top |  |  |  |  |  | Top |  | 1 |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-06-19 00:00:00 | 6 | 19
[NAME] | 2 |  | Bottom |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-06-24 00:00:00 | 6 | 24
[NAME] | 1 |  | Top |  |  |  |  |  | Top |  | 1 | 1 |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-06-29 00:00:00 | 6 | 29
Fred | 3 |  | Top |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-06-30 00:00:00 | 6 | 30
[NAME] | 1 |  | Bottom |  |  |  |  |  | Top | 1 |  | 1 |  | 2 | 2 |  |  | [NAME] | 1 |  | Top | 2011-06-30 00:00:00 | 6 | 30
[NAME] | 1 |  | Top |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-07-02 00:00:00 | 7 | 2
[NAME] | 2 |  | Bottom |  |  |  |  |  | Top |  | 1 |  | 1 |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-07-06 00:00:00 | 7 | 6
[NAME] | 1 |  | Top |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-07-07 00:00:00 | 7 | 7
[NAME] | 2 |  | Bottom |  |  |  |  |  | Bottom |  |  |  |  | 1 |  |  |  | [NAME] | 1 |  | Top | 2011-07-10 00:00:00 | 7 | 10
[NAME] | 1 |  | Top |  |  |  |  |  | Top |  |  | 1 |  | 1 |  | 1 |  | [NAME] | 1 |  | Top | 2011-07-17 00:00:00 | 7 | 17
[NAME] | 2 |  | Bottom |  |  |  |  |  | 26 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-07-19 00:00:00 | 7 | 19
[NAME] | 1 |  | Top |  |  |  |  |  | Top |  |  |  |  | 1 |  |  |  | [NAME] | 1 |  | Top | 2011-07-22 00:00:00 | 7 | 22
Fred | 3 |  | Top |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-07-24 00:00:00 | 7 | 24
[NAME] | 1 |  | Bottom |  |  |  |  |  | Top |  | 1 |  | 1 | 1 |  | 1 |  | [NAME] | 1 |  | Top | 2011-07-24 00:00:00 | 7 | 24
[NAME] | 1 |  | Top |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-07-25 00:00:00 | 7 | 25
[NAME] | 2 |  | Bottom |  |  |  |  |  | Top |  |  |  | 1 |  |  |  |  | [NAME] | 1 |  | Top | 2011-07-26 00:00:00 | 7 | 26
[NAME] | 1 |  | Top |  |  |  |  |  | 29 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-07-27 00:00:00 | 7 | 27
[NAME] | 2 |  | Bottom |  |  |  |  |  | Top |  | 2 | 1 | 1 |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-07-27 00:00:00 | 7 | 27
[NAME] | 1 |  | Top |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-07-27 00:00:00 | 7 | 27
[NAME] | 2 |  | Bottom |  |  |  |  |  | Top |  | 1 |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-07-31 00:00:00 | 7 | 31
[NAME] | 1 |  | Top |  |  |  |  |  | 31 |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-08-03 00:00:00 | 8 | 3
Fred | 3 |  | Top |  |  |  |  |  | Bottom |  |  |  | 1 |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-08-04 00:00:00 | 8 | 4
[NAME] | 1 |  | Bottom |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-08-04 00:00:00 | 8 | 4
[NAME] | 1 |  | Top |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-08-06 00:00:00 | 8 | 6
[NAME] | 2 |  | Bottom |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-08-07 00:00:00 | 8 | 7
[NAME] | 1 |  | Top |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-08-12 00:00:00 | 8 | 12
[NAME] | 2 |  | Bottom |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-08-18 00:00:00 | 8 | 18
[NAME] | 1 |  | Top |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-08-20 00:00:00 | 8 | 20
[NAME] | 2 |  | Bottom |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-08-21 00:00:00 | 8 | 21
[NAME] | 1 |  | Top |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-08-27 00:00:00 | 8 | 27
Fred | 3 |  | Top |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-08-28 00:00:00 | 8 | 28
[NAME] | 1 |  | Bottom |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Bottom | 2011-08-28 00:00:00 | 8 | 28
[NAME] | 1 |  | Top |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-08-28 00:00:00 | 8 | 28
[NAME] | 2 |  | Bottom |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1 |  | Top | 2011-09-02 00:00:00 | 9 | 2
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
Fred | 3 |  | Top
[NAME] | 1 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
Fred | 3 |  | Top
[NAME] | 1 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
Fred | 3 |  | Top
[NAME] | 1 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
Fred | 3 |  | Top
[NAME] | 1 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
Fred | 3 |  | Top
[NAME] | 1 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom
[NAME] | 1 |  | Top
Fred | 3 |  | Top
[NAME] | 1 |  | Bottom
[NAME] | 1 |  | Top
[NAME] | 2 |  | Bottom