|Hello. I am just learning Excel, so forgive me if there is a simple solution that I have missed!|
I am trying to find a way to calculate the difference between two letters of the alphabet in two different columns.
Column A is a set of letters of the alphabet indicating proficiency levels at certain time of year (where A is lowest, B is better, C is better sill, and so on through the alphabet to Z). Column B is another set of letters indicating proficency levels (From A through Z) at a different time of year.
I want to find the difference to show growth over time. For example, if the value at A1 is C and the value at B1 is H, the growth in C1 would be +5 levels.
Is there an easy way to accomplish this? Do I need to replace the letter A with the numeral 1, B with the numeral 2, C with the numeral 3, and so on to write this formula (and what is the easist way to do that?)