1. J

    Return single number value based on range

    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 /...
  2. L

    can excel help pick out top choice?

    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...
  3. L

    vlookup with approximate values

    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>...
  4. L

    reversing the order of 2 columns

    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"...
  5. most

    Copy value from other row into same column

    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>...
  6. L

    Formula for a seating plan

    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...
  7. B

    Add cell values to a TextBox

    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...
  8. S

    change code to stop sheet selecting or activating

    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...
  9. D

    Data extraction & population

    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...
  10. muhammad susanto

    Data Lookup With 3 Criteria Number (Positive,Negative & Zero) Percentage

    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...
  11. B

    lookup logic to interrogate specific exceptions - part 2

    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...
  12. A

    VBA Count add to Sheet2

    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...
  13. E

    Wondering whether a formula could assist or is even possible ...

    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...
  14. L

    Average grade from two columns

    <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?
  15. U

    Grade compare two non blank cells with alphabets and report trend

    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...
  16. U

    Grade using two range/conditions

    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...
  17. Y

    Rank with multiple column and criteria

    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...
  18. D

    Calculate GPA from Grade List

    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 A becomes 4.0; a B+ becomes 3.3, etc. I tried doing a vlookup for multiple lookup values. If I do...
  19. M

    'job & grade master (hide)' ???

    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)),"--")
  20. A

    Nested IF(AND Statement - Index Match or Array?

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

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
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 "".
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.
Go back