Prev: how to start with 0 in a cell in excel
Next: enormous formula bar and row height on opening excel
From: Steve Audus, Chaucer BEC, Sheffield UK on 21 Jan 2010 08:16
I am trying to use a Excel 2007 Piviot Table to translate this information

Name | Subject | Grade
Studentname 1 | Maths | D
Studentname 1 | Science | E
Studentname 1 | English | A
Studentname 2| Maths | A
Studentname 2 | Science | B
Studentname 2 | English | C

To a Privot Table like this

Name | Maths | Science | English
Studentname 1 | D | E | A
Studentname 2 | A | D | C

But it's showing this

Name | Maths | Science | English
Studentname 1 | 1 | 1 | 1
Studentname 2 | 1 | 1 | 1

Because in the Summery it's counting the grades.

How do I get excel just to show me the grade, and not count the grades?

thank you for any help.


From: Herbert Seidenberg on 21 Jan 2010 17:56
Excel 2007 Pivot Table
Convert numbers to letters
with custom font.
No extra formulas or helpers.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/01_21_10.xlsx
 | 
Pages: 1
Prev: how to start with 0 in a cell in excel
Next: enormous formula bar and row height on opening excel