I have 3 tables, person, activity and a log of activities, with a line for each person and activity.
Using Excel 2013 and relationships I was able to count the number of persons by activity, month, gender, etc.Please Login or Register to view this content.
But I cant get the average of persons by activity/month and the number of distinct activities by date.
Any ideas? Thanks
Bookmarks