Combine with a VLOOKUP() function. You can still keep your letter
grading system (1a. 1b. etc) but when you want to carry out your
calculation use VLOOKUP to return a number (1, 2, etc). At the end if
you want to transfer number back to grade, either round up or down
(depends on what you want) and use VLOOKUP again to return letter
grades.


Hope this helps.



London Wrote:
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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388459