| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data conversion: Text to Numeric to Support Averaging
I have a mix of grades (academic achievement) in numeric (98, 86, etc.) and
text (A, B+, etc.) format that I need to average for a final grade. While I can use LOOKUP variants to display the text as numeric, I have yet to figure out how to manipulate the text so it can be AVERAGEd with the numeric data. I am not totally new to Excel; however, I figured there are smarter folks in the community that may have already wrestled this issue into a solution. Congratulations! Please share your results...thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| averaging a column of letter grades into a numeric GPA | Excel Worksheet Functions | |||
| How to avoide data conversion when opening a text file? | Excel Discussion (Misc queries) | |||
| Prevent conversion of numeric text string to scientific notation | Excel Discussion (Misc queries) | |||
| converting text to numeric data | Excel Worksheet Functions | |||
| ASCII to Numeric Conversion | Excel Discussion (Misc queries) | |||
Threaded Mode
