Hi everyone,
I want to automate the way in which I keep track of which people show up for the weekend hikes based on a simple entry attendance. I have a simple table as follows:
<tbody>
</tbody>
Can you please help me obtain a simple descending attendance report like the example bellow:
Attendance: Mike (4x), Dan (3x), Melissa (3x), Alexandra (2x), Danielle (2x), Raphael (2x), Julie (1x), Robert (1x)
PS: I apologize in advance if my counting wasn't fully accurate. Also, I use MS Office 2007, if that helps in any way.
Thanks in advance.
I want to automate the way in which I keep track of which people show up for the weekend hikes based on a simple entry attendance. I have a simple table as follows:
A | B | C | D | E | |
1 | Date | 7 Oct | 14 Oct | 21 Oct | 28 Oct |
2 | Participants | Mike | Danielle | Mike | Danielle |
3 | Melissa | Dan | Dan | Julie | |
4 | Dan | Alexandra | Robert | Melissa | |
5 | Alexandra | Mike | Raphael | Mike | |
6 | Raphael | Melissa |
<tbody>
</tbody>
Can you please help me obtain a simple descending attendance report like the example bellow:
Attendance: Mike (4x), Dan (3x), Melissa (3x), Alexandra (2x), Danielle (2x), Raphael (2x), Julie (1x), Robert (1x)
PS: I apologize in advance if my counting wasn't fully accurate. Also, I use MS Office 2007, if that helps in any way.
Thanks in advance.