flipinoluv
Thread Starter
- Joined
- Apr 16, 2004
- Messages
- 21
I have an excel work sheet that uses colors in a matrix of people and skills they posses.
along the y axis would be the people, along the x axis would be the skill.
i am denoting colors, green=skilled, blue=needs refreshment, red=not trained.
I need to tabulate how many skills each person has.
Is there a way to be able to count the number of times a color, (i.e green) box occurs in a row/column?
along the y axis would be the people, along the x axis would be the skill.
i am denoting colors, green=skilled, blue=needs refreshment, red=not trained.
I need to tabulate how many skills each person has.
Is there a way to be able to count the number of times a color, (i.e green) box occurs in a row/column?