grade

My scenario is this, I have 2 grade tables for June and July. June Grade Table A - 100-95 B - 95-90 C - 89-80 D - 79-Below July Grade Table A - 100-97 B - 96-93 C - 92-89 D - 88-Below I am computing grades using these tables. What shall I do to retain the old grade computation for June now that...

Hi there, I am trying to find the number of non-repeated (unique/frequency) family names in each grade. I have prepared a sample and uploaded to one drive. I would appreciate it if someone could help? https://1drv.ms/x/s!AgQdYsSdg735fXy_R4rJuVlmcuw

Hello - In the example below, I have two worksheets: Worksheet 1 and Worksheet 2. I am trying to merge/match data from Worksheet 2 into Worksheet 1 so that the result is WORKSHEET Merged. Thank you for any help. <colgroup><col style="width...

I have some course data that has grade distributions. I would like to extract this data based on the course name and the semester when the course was taught. Is there a way to loop through a list of courses by semester, and lookup the grade data? In other words, start with ACC1013 and lookup...

Hi All, I'm using the below table for as a lookup. This works fine. My question is I would like a column that tells the pupil how many points from the next grade? For example a pupils scores 1341 which equals a MPP grade. They are 38 points from a MMP grade. How do I do this in a formula? 0...

I have a 3x3 migration matrix and I would like, based on the transition rates, to randomly choose which items to move from a state to another and keep the same distribution, for instance if i have this array: Pupil Grade Grade N+1 1 A A 2 A A 3 B A 4 B B 5 A B 6 A C...

Hi, I have been ripping my hair out trying to figure out how to find a formula with the data below: I need to show of the 29 staff who are Grade 4, what the total FTE is of anyone who is Grade 4 and the total FTE Could someone show me what the best formula would be to calculate this? Thanks...

I have created an Org Chart, but due to the size of it I want to generate rollovers, so hover over a name and a larger personalised image appears with the individual's details - name, role, grade, email, tel etc. Is there a simple way to do this? TIA

I want to lookup a "Grade" (unique number) based off of a text box input on a form. If the Rank in the form is equal to the Rank in the table, then show the corresponding Grade from said table. =DLookUp([tblGrades]![Grade],[tblGrades],[tblGrades]![Rank]=[txtRank]) The above doesn't work. Need...

Good afternoon folks, Any idea how I can convert data which looks like the below into 2 columns with grade and price using power query? Grade Amount Grade Amount Grade Amount Pxhg 1.34 hjuyt 2.56 kjui 1.45 jkuh 2.65 nhjy 1.45 klou...

I am using MsExcel 2016. On sheet test11 I have a list of (12000+ rows). Headed by Name and Grade and date. Data starts in A2 On sheet sheet2 I wish to group that data by say; name. test 1 example data (the name field does have the surname, first name middle name all in one column) Name...

Hi, I have a large dataset, about 4000 rows, which I need to correct some values in case of a criteria. Below is the example of my data: <tbody> Order ID Product Type Dollar Amount 11 Low grade 20 11 Premium 35 11 Low grade 10 12 Premium 50 12 Premium 20 12 Low grade 10 12 Low...

Hello Excel Experts, I want to find the grade. first lookup the maximum no. from A column from first row, then lookup the column B value from the prescribed range. <tbody> Maximum 10 20 30 40 60 100 RANGE GRADE RANGE GRADE RANGE GRADE RANGE GRADE RANGE GRADE RANGE GRADE 09 10 A+ 18 20...

Hi Friends, Case : Below table shows some product details, where in under column A we have only 2 product i.e. Product A & Product B. Column B represent product Group & Last column C represent Grade of (Product and its group). Excel Sheet 1. <tbody> A B C 1 Product Group Grade 2...

I am asking for assistance with a formula that is related to school grades that are both numerical and letter grades. In cell, A1 I will manually enter the numerical grade (Example: 84.25) In cell B1 I need a formula that returns a letter grade from a table that corresponds with the numerical...

Hi, When using conditional formatting in cells, if im showing an A grade and an A* grade I want them to show as different colours. I can't get conditional formatting to show them as different. Im sure its something really simple im not doing but my brain is fried today and i cant work it out...

How to tell following criteria in if function Employees who are in grade 1 are subject to 1% of basic salary Emoloyees in grade 2 are subjected to 2% of basic salary Employees in grade 3 are subjected to 3% of basic salary Calculate the service cost for each vehicle using the “Logical IF”...

I am using 'small' / 'large' to give a rank order of students, such that students are ranked according to their test score, which works well. However, we can only award a limited number of grades to each class, therefore, once I have ranked ordered the class, (it does this dynamically), I need...

I have a rather large dataset (sheet1) that contains names, year and grade Example key dataset fields Name Year Grade Fred bloggs 2000 A1 Mary Smith 2016 A2 john Jones 2017 A1 John Bloggs 2016 A3 Ros bloggs 2000 A3 I can filter / copy the data onto sheet 2 on any of the criteria But I would...

Hello all This is my first post on this forum and needed some help on what I am trying to do. I have data that stretches across a few cells and shows the grade the advisor received in date order and the formula I am trying to build is to check they competency rating and I want the formula to...