Hi
I have a grid with names in the first column, and the columns are individual subjects eg Biology Chemistry. The cells are populated with grades. I am trying to produce a report with Subjects in column 1 and a count for each subject of the numbers of A's B's etc.
I have used countifs quite effectively in the past but have been trying to use a Pivot Table. I have been wrestling with it for a few days and can't get the set up right. Is it possible?
thanks
I have a grid with names in the first column, and the columns are individual subjects eg Biology Chemistry. The cells are populated with grades. I am trying to produce a report with Subjects in column 1 and a count for each subject of the numbers of A's B's etc.
I have used countifs quite effectively in the past but have been trying to use a Pivot Table. I have been wrestling with it for a few days and can't get the set up right. Is it possible?
thanks