I keep a spreadsheet of energy meter readings and energy use calculated therefrom, and wish to be able to instantly compare calculated energy usage for the same period in previous years - see highlighted cells in attached sample spreadsheet.

Can this be achieved, please?

I assume there is a simple way to refer to the same reading date in previous years and work from there, perhaps?

Eventually I would like to use this data to provide a visual representation of usage over the years.


(Apologies if this seems simple, but please bear in mind that I am a relative novice at this sort of thing!)

Thanks.

Attached Files

Energy.xlsx (13.6 KB, 15 views)