Few questions
From: Neil Greenough (neilgreenough_at_btopenworld.com)
Date: 08/26/04
- Next message: Harald Staff: "Re: Input box hide typing"
- Previous message: Sean Goldsworthy: "Hide rows based on selection in drop down list...."
- Next in thread: Frank Kabel: "Re: Few questions"
- Reply: Frank Kabel: "Re: Few questions"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Aug 2004 13:20:03 +0000 (UTC)
It is exam results day in the UK today and so I am trying to analyse our
results and need some help.
Columns A & B = person info
Column C = Another number (see further down)
Column D = Tutor
Column E = Class
Column F = Target Grade
Column G = Mock Exam Grade
Column H = Actual grade.
Now within certain ranges within these columns, for example rows 1:30, I
want to do the following:-
- "Work out the percentage of grade A*-C grades for that group" - each entry
in column H has a grade ranging from A*, A, B,C,D,E,F etc.... I want to work
out how many of the letters in column H are actually A*, A, B and C.
- "Work out the target percentage of A*-C grades" - I want to work out in a
selected number of rows, for example rows 1:30, how many of the letters in
column F are A*,A,B,C.
- In column C, pupils all have different numbers ranging from 1-200. I want
to look at each row and if the number in column C is above 95, They should
have the letter A*, A, B or C in column H. I want to see how many do have
this and how many don't.
Any help would be appreciated
- Next message: Harald Staff: "Re: Input box hide typing"
- Previous message: Sean Goldsworthy: "Hide rows based on selection in drop down list...."
- Next in thread: Frank Kabel: "Re: Few questions"
- Reply: Frank Kabel: "Re: Few questions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
