Hi all,
I have uploaded a sample of my current attendance spreadsheet. As you can see it keeps track of
I was considering using a pivot table to be able to quickly check who has not filled their attendance quota (attend 6 events a year and organise 1), how many events had been held in certain date periods, whether the 'squires' had attended their required 4 events to become 'knights' and various other information.
I have looked at many other attendance tracking sheets, but these usually are not concerned with dates and organisers of events.
I have exhausted my own knowledge bank in trying to make this happen and if anyone could provide suggestions I would greatly appreciate it.
Thanks
I have uploaded a sample of my current attendance spreadsheet. As you can see it keeps track of
- The name of the event;
- Who has attended what event;
- Who organised each event and;
- The date of every event;
I was considering using a pivot table to be able to quickly check who has not filled their attendance quota (attend 6 events a year and organise 1), how many events had been held in certain date periods, whether the 'squires' had attended their required 4 events to become 'knights' and various other information.
I have looked at many other attendance tracking sheets, but these usually are not concerned with dates and organisers of events.
I have exhausted my own knowledge bank in trying to make this happen and if anyone could provide suggestions I would greatly appreciate it.
Thanks