Assume a table which lists attendees for a Company’s Annual day function. In this Table, data for every attendee is shown on a separate row so if an employee attends the function with his/her spouse and three children, then there will be 5 rows for that employee.
The question is to determine the count of the following family configuration:
1. Employees only (those who attended without spouse and children); and
2. Employees, spouse and children (Family); and
3. Employees and spouse (no children); and
4. Employees and children (no spouse)
You may refer to my solution in this workbook. I have solved this problem using:
1. MS Excel Formulas based on Set Theory and Venn Diagram; and
2. PowerPivot
Compute configuration count using Set Theory and Venn Diagrams
{ 0 Comments }