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.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
--TripWire--

8/22/2022 - Mon
SOLUTION
Steve

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Steve

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
--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?
--TripWire--

ASKER
My question was answered for the most part in the actual files.  However, I would have found further explanation even more useful.
Your help has saved me hundreds of hours of internet surfing.
fblack61