Heya, im barely great at Excel, and im struggling to develop a formula.
I have one sheet that has a Numeric result in ONE cell - S2
The number is ANY value, with ANY decimal point value
I need to put a formula in another cell that defines a grade 1-5 based on its value S2's value.
*Each Peak /...
let say i have a group of kids that get to pick out their three favorite toys. Because the number of toy available is limited, only the kids with he highest grade get their #1 choice 1. the rest get their 2nd or 3rd choice depend on their grade and availability.
<tbody>
kids
grade
# 1...
Hi
The vlookup = =VLOOKUP(B2,$H$2:$I$5,2,1) with approximate values is working if the table like this
This table start H2:I5
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
average
grade
0
f
50
c
60
b
80
a
</tbody>...
Hi
Is there any way/trick to reverse a table without using sorting? Here is my table
From
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
average
grade
0
f
50
c
60
b
80
a
</tbody>
To
<colgroup><col width="64" span="2"...
Hello,
I need help with solving this issue, I want to find and fill data from another row and paste into same column.
I thought VLOOKUP could solve it, but it only works "down", not "up".
Orginal data looks like these
<tbody>
ID
Grade
123456
123456
Y_15
654321
Y_16
654321
</tbody>...
Hi all,
I have another task that i hope you can help me with :)
I have a spreadsheet that looks like this.
COLUMN A, COLUMN B, COLUMN C, COLUMN D, COLUMN E
Firstname , Surname , Location , Grade , Table no.
Bill , Smith , London , 1 , 1...
I have a bid form and in column R there is a predefined list of items, and in column S there is a predefined list of reasons. I would like a way to populate a TexBox with those values
Example:
R37 = Spread Footings; S37 = Blank
R38 = Grade beams; S38 = GB1-10
I would like code to then put the...
Hi All
I want to change my code to just run without activating or selecting the sheet.
Its not a major problem of course, but its just neater.
I have been trying to figure it out, but cannot, so please see code below that works.
It loops the 6 sheets and then goes back to the main...
Is it possible to automate the following;
I have 2 sheets. Sheet2 is raw data with 8 columns and dynamic number of rows. Sheet1 is blank and will extract data from Sheet2.
In Sheet2;
- column A is populated with unique student ID
- column E is populated with their exam grade
- column G has...
hi all..
i have a problem to data lookup with 3 criteria number (positive percentage number,negative percentage number,zero number)
for easy to understand maybe like below layout table :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC...
Hello,
If (Col B) Manager is equal to: Brian OR Mike OR Shawn then, using the grade field (Col A) output the corresponding average value associated in Sheet2 (Col D and E)
If (Col B) Manager is equal to: Julie OR Sharon OR Liz then, using the grade field (Col A), output the corresponding...
I have about 40,000 rows of data on sheet1 like below. What I need to do is to give a summary of grade level on sheet2. Please see below data.
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica...
Hi all
I work for an education facility and a number of times throughout the year I have to manually check student grades for accuracy. I can have up to 40 spreadsheets with up to 300 students per sheet so it is quite a time consuming process. I am wondering whether a formula might help...
<tbody>
2
10%
3
5%
5
35%
7
27%
9
23%
</tbody>
I have these two columns in Excel file. The first one with grades, the second with percent how many students get that grade. How to calculate average grade from this data?
Dear MrExcelites,
Greetings, I need a formula to compare the last and the last second cell and report whether it has increased or decreased or stays the same.
Grade Table:
Book1BCDEFGHIJKLM1JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC2BBSheet1
Used below formula, but with error.
Trend Result...
Dear MrExcelits,
Need help in deriving Grade A to E using two sets of data.
Tried my best and stuck.
Please help in formula.
No macros please as I would share this file.
Example as below:
Grade Table to consider:
Book1BCD2GRADEQUALITYDELIVERY...
Hi pals. I am creating an excel to rank the achievement of pupils. Please help me to write a formula to rank them according to multi column and criteria:
1. Rank those with 0 Grade E first, then only follow with those with >0 Grade E
2. For those with 0 Grade E, rank Grade A, follow by Grade B...
I am doing admin for a college department. I want to enter the student's grades in A1:A10, for example, and in one cell, to convert those grades to grade points...an A becomes 4.0; a B+ becomes 3.3, etc.
I tried doing a vlookup for multiple lookup values. If I do...
Does the parenthesis HIDE in this formula mean the sheet is hidden? I checked the workbook and there are no hidden sheets. Does this mean it's from another workbook?
=IFERROR(CONCATENATE("S",VLOOKUP(B2039,'JOB & GRADE MASTER (HIDE)'!$A$1:$C$996,3,FALSE)),"--")
Hi,
I am trying to work out who in my data is eligible for a pay increment. I have a 2 column lookup table $A$2:$B$28 that shows Grade in Column A and Scale Point Ceiling in Column B
e.g.
Column A
GRADE
Column B
SCALE POINT CEILING
Administrator...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.