How to convert letter grade to number in Excel?
If you have a sheet which contains student names and the letter grades, now you want to convert the letter grades to the relative number grades as below screenshot shown. You can convert them one by one, but it is time-consuming while there are so many to convert. Here I introduce VLOOKUP function to quickly deal with this job in Excel.
Combine rows based on another column value in Excel
|Here is a table which contains two columns, one is the student names, another is the grade letter.What the job is to combine the names based on the same grade letter. In Excel, there is no built-in function can quickly solve it, while Kutools for Excel's Advanced Combine Rows utility can do you a favor. You can combine rows based on a key column, also can calcualte rows based on column. Click for 60 days free trial!|
|Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days.|
Before using VLOOKUP function to convert letter grade to number, you need to create a sheet which contains letter grades and their relative number grades as below screenshot shown:
Select the cell you want to place the number grade, type this formula =VLOOKUP(B2,GPA!A:B,2,FALSE), press Enter key.
Then drag the fill handle down to apply this formula to cells.
Note: In the formula, B2 is the letter grade you want to convert to number, GPA is the sheet name contains number grade, A:B are the letter grade and number grade column range, 2 indicate to look up value in the second column.