| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
assigning value to a column based on a table of values
I am correcting an exam and I have automatically generated the score of the
students. These I have in columns. Further I have a translation code that showes how a score relates to a grade. this is shown below. Here the interval from min to max is the score that produce the grade. For example if the score is between 2 and 5 the grade is 5. How do I make the translation from score to grade automatically? min max grade 0 2 3 2 5 5 5 6 6 6 7 7 7 8 8 8 11 9 11 18 10 18 23 11 Jacob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Lookup values in one column to return another | Excel Worksheet Functions | |||
| How to get the values using a condition refering to the other column | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
