Greetings all,
I have a data on 3 columns
column A: 48 months (eg May-2007, Jun-2007, Jul-2007...Apr-2011)
column B: 4 items A, B, C and D randomly filled out 48 rows (1 item per cell, eg. A,C,C,D,B,A,B,A,C,B,D,D,A,B,C,...)
column C: Scores of 1-5 randomly
I created on column D to find out the cumulative scores for each of the line. So I know the most current cumulated scores on A, B, C and D towards the bottom of the list. This part is easy. But I can't come up with an answer on the two following questions.
Questions:
1. (Major) Is there an easier way to show on the same or a different worksheet where A, B, C, D stand on the cumulated scores on any given month? If this can be done then I can create just one graph showing how the scores changes over time on A, B, C and D
2. (Minor) The list will continue to grow as time passes. How will the formulae in Q1 differ if I keep adding new monthly scores?
I have a data on 3 columns
column A: 48 months (eg May-2007, Jun-2007, Jul-2007...Apr-2011)
column B: 4 items A, B, C and D randomly filled out 48 rows (1 item per cell, eg. A,C,C,D,B,A,B,A,C,B,D,D,A,B,C,...)
column C: Scores of 1-5 randomly
I created on column D to find out the cumulative scores for each of the line. So I know the most current cumulated scores on A, B, C and D towards the bottom of the list. This part is easy. But I can't come up with an answer on the two following questions.
Questions:
1. (Major) Is there an easier way to show on the same or a different worksheet where A, B, C, D stand on the cumulated scores on any given month? If this can be done then I can create just one graph showing how the scores changes over time on A, B, C and D
2. (Minor) The list will continue to grow as time passes. How will the formulae in Q1 differ if I keep adding new monthly scores?