Link to home
Start Free TrialLog in
Avatar of --TripWire--
--TripWire--

asked on

How to distinguish between columns in MS Excel

Hello,

I have a MS Excel spreadsheet that I'm helping develop for someone who is using it as a grading sheet.  I'm using someone else's version as a template.

There is room for 20 pieces of work from each student in the class (plus additional exams, etc.)  What he wants to do is be able to distinguish between the columns which assignments were coursework and which was homework, so that they may be weighted differently in the final grade.

If that explanation was confusing, consider this...

I have 20 columns, each with percentage marks in them.  The teach won't know until the school year begins where the homework will fall in the schedule and where the classwork will fall.  I want for him to be able to highlight the columns that were homework and 'mark' it somehow, so that a formula that I will provide will weight the HW differently than the classwork.

I hope that helps.  Please let me know if you need any further clarification.
Thank you.
SOLUTION
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of --TripWire--
--TripWire--

ASKER

Thanks for the replies.  But I'm having a little trouble following your logic.
Can you either explain to me what you're doing in your examples in detail.... or

suppose I have the following

CW     CW     HW     HW     AS
80     55        98      77       75

If I enter in Coursework, Homework or Assignment as I go along, how can I weight them differently in my total?
My question was answered for the most part in the actual files.  However, I would have found further explanation even more useful.