Spreadsheet: 268423d1380633738-nested-formula-function-to-count-unique-entries-excel_forum_query-copy
Sheet: DAY TO DAY

DATE | DAY OF WEEK | Event Location | Event Coordinator | CON. # | FIRST NAME | LAST NAME | Event Manager
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | Walmart - Milner |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | Walmart - Milner |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | No Frills - Cedarbrae |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | No Frills - Cedarbrae |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | Metro - Markham Rd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | Canadian Tire - Cedarbrae |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | Canadian Tire - Cedarbrae |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | Pet Value - Don Mills |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | Pet Value - Don Mills |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | Walmart - Milner |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0
2013-09-30 00:00:00 | 2013-09-30 00:00:00 | Walmart - Milner |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0