grade

Hi I have a sheet where we have 15 values in a row 22 44 23 44 55 48 58 32 52 29 33 44 25 56 55 Now i want to know how many times 20 to 30 come in row 1 to 15 in continuing. And If i want to put a value, how can, i mean If 10 to 20 comes in first row then A grade Again If 10 to 20 comes in...

Hi all, I need to create a formula that will return the Name and the Favorite Color of a person according to the following: 1) Age = 17 2) Highest grade. <tbody> Name Age Grade Favorite Color John 17 99 Blue Stefan 26 99 Red Jake 17 78 Pink Donna 28 98 Green Sam 36 85 Blue...

I've inherited an Excel file used for scheduling that has multiple timeslots in one cell - a formatting nightmare! Is there a way to easily split these (like the text to columns) except for rows? Thanks! example row: <tbody> Computer Lab 1 8:00-8:50 open 9:00-9:30 open...

Hi guys, I am working in Design view of a query. I have two tables below. I want to add a formula in query formula window to help calculate the new grade based on the 10% improvement. In Excel I could do it via Match formula, how can I do this in Access? Table A: Grade...

Hello, I thought I was done with my school application project,until I was challenged with another task. In the application there is a report card that shows the first term,second term and third term report when you click "Open Report Card" in the form "frmStudent" a dialog form pops up to...

Good morning everyone! I have spread sheet with student grades. The grades range from 1 to 9. Each student is a group. There are 4 groups: Group 1, Group 2, Group 3 & Group 4. I have a summary sheet. I'm counting up each individual glade for each group. This works fine. Formula here...

I am looking for an IF formula for...number of severance weeks based on salary grade level...for example: IF grade level 21-25 receives 10 weeks of severance @ [amount] (based on individual salary) IF grade level 26-27 receives 12 weeksof severance @ [amount] (based on individual salary) IF...

I need a formula that compares two columns and tells me if a grade has gone up, down or stayed the same. The table I am trying to populate is similar to the one below: <tbody> A B C D E Grade Year 10 TA4 Year 11 TA1 9...

I have a grade book for a school. It is shared online for teachers and staff to use/edit. Due to the number of formulas it can get kind of bogged down. So I am looking to save some processing power and accomplish the same task. A teacher enters a percent in cell then the cell below has a...

Hi, I'm trying to create a grade sheet to track my students' progress. I've been searching all over and can't figure this out. I would like to be able to see each students' grade-in-progress, according to current assignments/exams. Here's a link to what the spreadsheet looks like...

Hi I am new to power queries. I am a teacher and try to accumulate all the score for the whole school. I have 15 subjects and each subject have 15 classes to pull the score in. My goal is to be able to receive all the subject scores for each classes(15 sheets in 1 excel). Something like this...

Hi Everyone, I was wondering if anyone had an idea on how to clean this data table.Using a tool in excel. Maybe power query? I have multiple sites as a row and for each grade I have merged column. e multiple formulas. Merged Column (Lead Time by Grade) Merged...

This should be easy, but I keep messing it up. The quizzes in a class I'm teaching add up to 60% of the grade. The exam counts for 40 percent. Suggest a formula? Student has a 65 average for the quiz portion, 36 for the exam. Thanks in advance.

Hi I use vlookup to find the grade of each student (last argument is TRUE). My question why the grade table "has to" be sorted from smallest to the largest otherwise vlookup wont work. It wont work if the table was like this <colgroup><col width="64" span="2" style="width:48pt">...

Hello I am in need of some help when adding the overall grade as well as grade weights. Right now I have N/A's (Column P-R) defaulting to 1 if there is no grade.I am afraid this is still not correct. I think the grade is being over inflated with N/A's making the supplier's grade look better...

Hello guys, Every month I need to distribute a number of companies to be assessed by diferently graded analysts. This distribution is based on a matrix that attributes authority according to the internal rating/grade that a given company has and also what exposure that company holds. <tbody>...

Hi I have a table like the one below. What I want, I want to create dynamic chart that show one grade at a time. So if a user select A then the percentage of A will appear as below and then the chat will show A and its %. I am thinking that could be done with data validation but I not sure how...

hi I have table like the one below. I calculate grade using if() function, a for >80, b for >70 etc. The I used countif() to find out how many a,b,c, and f, I have. a = 1 b = 10 c = 3 f = 4 My question, I want excel to give me the percentage % of a, b, c, and f. so I want to have something...

<tbody> Grade Name Date Terry 00-01 James 00-01 Terry 01-02 Bob 01-02 James 02-03 </tbody> TABLE 1 <tbody> Date Name Grade 00-01 Terry A 01-02 James C 00-01 Terry B 01-02 James D </tbody> TABLE 2 Hey guys, I'm looking to write a formula in the 'Grade'...

Morning all I am looking for VBA to enable me to search my spreadsheet where the 'Grade' column is equal to 'APP' I have the autofilter as Sub check3() Range("A:1:X1").Autofilter6,"=APP" I know I may not need this, but want to leave it in, to let users see it has worked. What I am looking...