danhodges99
New Member
- Joined
- Apr 22, 2009
- Messages
- 12
Hi – I hope you can help, this is proving beyond me…
I have two tables. The first contains the data, in this case a list of activities carried out in a personal fitness log and the date of each:
<tbody>
</tbody>
The second table is meant to be a dashboard calendar summary of the number of each activity on each date, and should look like this:
<tbody>
</tbody>
I’ve almost managed it using INDEX & MATCH. However, when a day has multiple activities, the calendar view only captures the first activity on each day and ignores the rest – leaving my figures inaccurate.
Any help here is greatly appreciated - thanks.
I have two tables. The first contains the data, in this case a list of activities carried out in a personal fitness log and the date of each:
Date | Activity | |
01/08/2016 |
<tbody> </tbody> | |
01/08/2016 | Cycling | |
02/08/2016 | Running | |
02/08/2016 | Rowing | |
02/08/2016 | Gym | |
05/08/2016 | Running | |
07/08/2016 | Running | |
07/08/2016 | Running | |
07/08/2016 | Running | |
07/08/2016 | Gym | |
07/08/2016 | Cycling | |
09/08/2016 | Rowing | |
10/08/2016 | Rowing | |
10/08/2016 | Running | |
10/08/2016 | Running |
<tbody>
</tbody>
The second table is meant to be a dashboard calendar summary of the number of each activity on each date, and should look like this:
Date | Rowing | Running | Cycling | Gym |
01/08/2016 | 0 | 1 | 1 | 0 |
02/08/2016 | 1 | 1 | 0 | 1 |
03/08/2016 | 0 | 0 | 0 | 0 |
04/08/2016 | 0 | 0 | 0 | 0 |
05/08/2016 | 0 | 1 | 0 | 0 |
06/08/2016 | 0 | 0 | 0 | 0 |
07/08/2016 | 0 | 3 | 1 | 1 |
08/08/2016 | 0 | 0 | 0 | 0 |
09/08/2016 | 1 | 0 | 0 | 0 |
10/08/2016 | 1 | 2 | 0 | 0 |
<tbody>
</tbody>
I’ve almost managed it using INDEX & MATCH. However, when a day has multiple activities, the calendar view only captures the first activity on each day and ignores the rest – leaving my figures inaccurate.
Any help here is greatly appreciated - thanks.