1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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: <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...

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

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...