Need help comparing letters as figures for quantitative data analysis

**t-money** · 06-05-2013, 08:10 AM

hi all,

would like to enquire into ur collective knowledge.

I work in a college and obviously grades are the biggest thing that guide us...i have grades but i wud like to compare them. by this i mean i have one grade for a specific student from october and then january and then april. i would like to compare the three. they are however letters (and not number fields) so how wud i set up a worksheet so that it will compare january with april and then issue a '+' if the grade is improving and a '-' if the grade is falling.

thanks v much

**sput_sput** · 06-05-2013, 08:40 AM

i have attached a file with i think would work, in columns C,D i have attached a numerical value to a grade, its should be easy to follow.

hopefully this is what your after

**t-money** · 06-05-2013, 10:20 AM

omg. wow. im impressed with the response and care with which you took to do this. i will try and learn how it was done so i can repeat over and over. many many thanks sput-sput