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