John,

To convert the assessment in, say cell F20, to the appropriate number try:

=3*(CODE(F20)-48)-(2-(CODE(UPPER(RIGHT(F20)))-65))

ie 5c will be converted to 15

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"London" wrote in
message ...

Bit complicated for me... might be easier for someone tho..

I have a set of school assessement data that runs 1a 1b 1c 2a 2b 2c
etc. I have to gather together 3 codes and calculate an average. So
like someone may get 2b 2b 3b so there average might be say 3a
sort of...

I have thought about doing this:

1a = 1
1b = 2
1c = 3
2a = 4
2b = 5 etc

That will give me an average or sorts. But can i send up a worksheet so
that i can continue using the codes of 1a 1b etc?

John
London


--
London
------------------------------------------------------------------------
London's Profile:
http://www.excelforum.com/member.php...o&userid=25363
View this thread: http://www.excelforum.com/showthread...hreadid=388459