dear experts,
what formula can i use for an array like from a month calendar (boxes) in which I can have the list (type) of schedules within every dates of the month.
<tbody>
</tbody>
in which I want a list like this:
date 5 - activity E
date 5 - activity Z
date 10 - activity Q
date 6 - activity M
What formula within the array can I use to have the list type of schedule ?
Thank you in advance dear experts
what formula can i use for an array like from a month calendar (boxes) in which I can have the list (type) of schedules within every dates of the month.
1 | 2 | 3 | 4 | 5 |
activity A | activity B | activity C | activity D | activity E |
activity V | activity W | activity X | activity Y | activity Z |
6 | 7 | 8 | 9 | 10 |
activity M | activity N | activity O | activity P | activity Q |
<tbody>
</tbody>
in which I want a list like this:
date 5 - activity E
date 5 - activity Z
date 10 - activity Q
date 6 - activity M
What formula within the array can I use to have the list type of schedule ?
Thank you in advance dear experts