Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot to show a Grade and not count it..
I have a very large worksheet set out like this
Student name Subject Grade Student 1 Maths A Student 1 English B Student 1 Science C Student 2 Maths A Student 2 English B Student 2 Science C Student 3 Maths A Student 3 English B Student 3 Science C Using a Pivot table I'd like it to appear like this Student Name English Maths Science Student 1 A B C Student 2 A B C Student 3 A B C But it keeps wanting to count the grades, I'd just like it to show it? Row Labels English Maths Science Student 1 1 1 1 Student 2 1 1 1 Student 3 1 1 1 Any Suggestions, Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to compute letter grade based on percentage grade | Excel Discussion (Misc queries) | |||
when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
when doing a grade book how do you drop the lowest grade | Excel Worksheet Functions | |||
Getting a pivot table to show the count of blank cells in a worksh | Excel Discussion (Misc queries) | |||
Grade Percentage into letter grade | Excel Discussion (Misc queries) |