LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 13th 15, 11:01 AM
Junior Member
First recorded activity by ExcelBanter: Feb 2015
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  
Old February 13th 15, 02:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Feb 2011
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?


Free usenet access at
Classic VB Users Regroup!

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 03:45 PM
Comparing data of two sheets sriramkanala Excel Programming 0 February 9th 06 02: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 02:02 AM
Comparing sheets data Vytautas Excel Discussion (Misc queries) 1 February 15th 05 10:01 AM

All times are GMT +1. The time now is 09:52 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017