Beddy Boy
New member
- Joined
- Feb 1, 2017
- Messages
- 48
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 365
Hi,
I would really appreciate some help in setting up a spreadsheet.
I have a table with pupils ID numbers followed by a score for a test in the adjacent column.
I wish to set up a table where pupils ID numbers are set out in a table automatically depending on their score - A 0-5, B 5-10, C > 10
Then following this, Another table where the average scores are displayed.
A B C
T1 3.5 9 15 etc. etc.
Please can anyone help with coding for this?
Many thanks,
Wayne
I would really appreciate some help in setting up a spreadsheet.
I have a table with pupils ID numbers followed by a score for a test in the adjacent column.
P | T1 | P | T2 | P | T3 |
2 | 3 | 3 | 2 | 1 | 1.5 |
4 | 4 | 5 | 4 | 2 | 15 |
5 | 8 | 7 | 8 | 5 | 9.5 |
7 | 9.5 | 9 | 9 | 7 | 6 |
9 | 15 | 10 | 11 | 11 | 12 |
11 | 12 | 14 | 15 |
I wish to set up a table where pupils ID numbers are set out in a table automatically depending on their score - A 0-5, B 5-10, C > 10
A | B | C | |
T1 | 2,4 | 5,7 | 9 |
T2 | 3,5 | 7,9 | 10,11 |
T3 | 1 | 5,7 | 2,11,14 |
Then following this, Another table where the average scores are displayed.
A B C
T1 3.5 9 15 etc. etc.
Please can anyone help with coding for this?
Many thanks,
Wayne