Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,177
- Office Version
- 365
- 2019
- Platform
- Windows
I have VBA for this but I am looking to solve this with your help with a Dynamic Array. I am looking for a Dynamic array of employees and schools. Each x represents 0.2 for a day. Sometimes a person will be at multiple schools in a day. So if the employee goes to 2 schools in a day then it would be 0.1 for the first school and 0.1 for the second school.
For employee 111
In this example 111 at School Washington Works W and TH. Wednesday is also at Lincoln and Thursday at Lincoln so 0.1 for W and 0.1 for TH = 0.2.
At Lincoln M 0.2, T 0.2, W 0.1, TH 0.1, F 0.2 = 0.8
For employee 111
ID | Last Name | First Name | School | M | T | W | TH | F |
111 | AAA | A | Washington | x | x | |||
111 | AAA | A | Lincoln | x | x | x | x | x |
In this example 111 at School Washington Works W and TH. Wednesday is also at Lincoln and Thursday at Lincoln so 0.1 for W and 0.1 for TH = 0.2.
At Lincoln M 0.2, T 0.2, W 0.1, TH 0.1, F 0.2 = 0.8
|