claytont454
New Member
- Joined
- Feb 28, 2013
- Messages
- 8
Hi folks, I've been solving this so far by doing lots of steps and thought someone might have a better idea.
My real application is counting vaccinations that are given in different combinations, but to make this shorter, I'll pretend that the people are students in a painting class that ran for 3 sessions. Each student can use red, blue, or yellow each day, and if they use green or orange, those count as 1 each of the primary colors (green=1 blue + 1 yellow, orange=1 red + 1 yellow). Here is their color usage, followed by the results that I'm calculating manually.
<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>
How can I use Excel to get the following table, hopefully with little or no programming?
Thanks in advance for your ideas!
Results: How many of each color did each student use?
<colgroup><col span="5"></colgroup><tbody>
</tbody>
My real application is counting vaccinations that are given in different combinations, but to make this shorter, I'll pretend that the people are students in a painting class that ran for 3 sessions. Each student can use red, blue, or yellow each day, and if they use green or orange, those count as 1 each of the primary colors (green=1 blue + 1 yellow, orange=1 red + 1 yellow). Here is their color usage, followed by the results that I'm calculating manually.
A | B | C | D | E | |
1 | Name | Color used | Session1 | Session2 | Session3 |
2 | Billy | Red | 1 | ||
3 | Billy | Orange | 1 | ||
4 | Billy | Blue | 1 | 1 | 1 |
5 | Sally | Purple | 1 | ||
6 | Sally | Blue | 1 | ||
7 | Gina | Green | 1 | 1 | |
8 | Fred | Yellow | 1 | 1 | |
9 | Fred | Orange | 1 |
<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>
How can I use Excel to get the following table, hopefully with little or no programming?
Thanks in advance for your ideas!
Results: How many of each color did each student use?
A | B | C | D | |
1 | Red | Yellow | Blue | |
2 | Billy | 2 | 1 | 3 |
3 | Sally | 1 | 0 | 2 |
4 | Gina | 0 | 1 | 1 |
5 | Fred | 1 | 2 | 0 |
<colgroup><col span="5"></colgroup><tbody>
</tbody>