Calculating difference between grades to show improvements

Hi I hope you can help. I have a spreadsheet with energy ratings for buildings over various years. Energy ratings go from A to G. Is there any way i can show whether building has improved or got worse. For each year i have a column for grade.


Thanks for your help. Im using excel 2010.

One way:

Please Login or Register  to view this content.