Letters = Numbers
 

I want to use 'ms'=4 , 's'=5, 'p'=2, 'j'=10
so that when I type these letters into a cell I can then run an averag
based on the letters that will come back with a numeric figure.

How do I do this

--
oberon.blac
-----------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673
View this thread: http://www.excelforum.com/showthread.php?threadid=48101

Letters = Numbers
 

You could use a helper column to set a value based on the contents o
the cells, e.g.:

=CHOOSE(MATCH(A1,$F$1:$F$4),4,5,2,10) copied down in col B with you
list of criteria in F1:F4 (ms,s,p,j) would read the cells in Col A an
return the listed values or #N/A if not matched.

Then =AVERAGE(Bn:Bnnn) gives you the average of this range

Does this work for you

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=48101

Letters = Numbers
 

You could use a helper column to set a value based on the contents o
the cells, e.g.:

=CHOOSE(MATCH(A1,$F$1:$F$4),4,5,2,10) copied down in col B with you
list of criteria in F1:F4 (ms,s,p,j) would read the cells in Col A an
return the listed values or #N/A if not matched.

Then =AVERAGE(Bn:Bnnn) gives you the average of this range

Does this work for you

--
swatsp0

-----------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...fo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=48101