A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data conversion: Text to Numeric to Support Averaging



 
 
Thread Tools Display Modes
  #1  
Old May 27th, 2010, 10:57 PM posted to microsoft.public.excel.newusers
Frogs5
external usenet poster
 
Posts: 1
Default 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!
  #2  
Old May 28th, 2010, 03:01 PM posted to microsoft.public.excel.newusers
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Data conversion: Text to Numeric to Support Averaging

You'll need to first create a helper column. Assuming you have a lookup
table setup somewhere to convert the text to numbers, can do:
=IF(ISNUMBER(A2),A2,LOOKUP(A2,Your_Table))

Then average the helper column.

--
Best Regards,

Luke M
"Frogs5" wrote in message
...
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
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.