Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Comparing grade data across sheets

I am focusing on creating a spreadsheet that will compare students' grade data throughout the year. That means, on sheet 1 with be September - December, sheet 2: January - April, sheet 3: April - July.

I want to be able to compare whether has student has improved or declined in two categories Category 1: Effort (A*-E), Category 2: Attainment (1-6)

So student x could get B 2 for Maths in Autumn, but A 3 for Maths in Spring. I want my spreadsheet to highlight green for the improvement of B to A and then red for the decrease to 3.

I'm having trouble with creating something that will conditionally format the whole data across two sheets, I managed to do it for one student's attainment cells, but am not sure how to do it for all at once. Also, there is the issue of stating that A* is greater than an A etc.

Does anyone have any ideas about this?

Different students grades will be shown like this, with different subjects across the horizontal axis (so to speak)

Effort Attainment
C 3
A 2
B 3
C 3
B 2
C 3
A 2
B 3

Any help is greatly received!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,514
Default Comparing grade data across sheets

My StudentGradesManager app handles per semester at the instructor
level, per year at the admin level. The admin worksheet summarizes by
semester for Avg, GPA, and letter grade, thus 3 cols per semester. It
uses the MIN()/MAX() functions to do similar to what you want. Perhaps
you can look at using those on a consolidation (summary) sheet?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing Data on 2 sheets Lee Excel Discussion (Misc queries) 1 November 25th 08 04:45 PM
Comparing data of two sheets sriramkanala Excel Programming 0 February 9th 06 03:59 PM
Comparing data of two sheets shenlingstyle Excel Programming 0 September 29th 05 06:57 PM
Comparing Data between two sheets AChesley Excel Worksheet Functions 1 February 17th 05 03:02 AM
Comparing sheets data Vytautas Excel Discussion (Misc queries) 1 February 15th 05 11:01 AM


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"