LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default Teaching Sub-Levels and Excel Nightmare

Hi, I am a school teacher and when we level pupils they receive a level and
then a sub level, which is unfortunately a letter, eg: 6C (being the lowest
of three sublevels in the 6s up to 6A being the highest, then onto 7C etc).

I have a level from last year, and want to compare that to their current end
of year level. I have beein saying that 6C is 62 and 6B is 65 and 6A is 68
but I find this confusing. I'd like to be able to say using some formula or
something that if they were 6C at the start of the year and are now a 6A,
then they have moved up 2 sublevels (+2 or something). Is there any way of
doing this without using my 62, 65, 68 solution????

Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need An Idea For Teaching VBA dhstein Excel Discussion (Misc queries) 5 August 10th 09 05:47 PM
Wrong Teaching of Excel Scott Excel Discussion (Misc queries) 6 May 29th 08 12:40 AM
Need a function for my teaching plans ArthurN Excel Worksheet Functions 5 April 5th 08 06:49 AM
Excel - Word Link NIGHTMARE! Z_Webnut Excel Discussion (Misc queries) 0 September 9th 05 08:42 AM
Teaching VBA programming Microsoft Forum Excel Programming 1 December 12th 04 08:19 PM


All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"