Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2021, 01:44 AM
silverman166 silverman166 is offline Compare data values for same period in previous year Windows 10 Compare data values for same period in previous year Office 2007
Advanced Beginner
Compare data values for same period in previous year
 
Join Date: Nov 2019
Posts: 31
silverman166 is on a distinguished road
Default Compare data values for same period in previous year

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
File Type: xlsx Energy.xlsx (13.6 KB, 13 views)
Reply With Quote
  #2  
Old 05-01-2021, 04:08 PM
p45cal's Avatar
p45cal p45cal is offline Compare data values for same period in previous year Windows 10 Compare data values for same period in previous year Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Merge your 2 years tables into one and pivot the data.
In the attached two sheets with slightly different arrangements of pivot tables, on the second sheet a chart too.
I think you're using Excel 2007 so I hope the pivots are still compatible.
Attached Files
File Type: xlsx msofficeforums46902Energy.xlsx (28.3 KB, 18 views)
Reply With Quote
  #3  
Old 05-02-2021, 03:08 AM
silverman166 silverman166 is offline Compare data values for same period in previous year Windows 10 Compare data values for same period in previous year Office 2007
Advanced Beginner
Compare data values for same period in previous year
 
Join Date: Nov 2019
Posts: 31
silverman166 is on a distinguished road
Default

Thanks, that looks really useful.


Pivot Tables are a new concept for me, but I've found guidance on how to set one up on Excel 2007, so will have a go later.


Thanks again.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to calculate the Average time period of a full oscilation on a set of data DDK2110 Excel 2 05-27-2017 02:15 AM
Compare data values for same period in previous year Compare & remove both sets of duplicate values mummy Excel 1 03-28-2016 02:59 AM
How to calculate a rolling year-to-date percentage by quarter as the year progresses sleake Excel Programming 2 04-23-2015 11:51 AM
Compare data values for same period in previous year using if and compare with multiple criteria and ranges of values bill3kradio Mail Merge 7 11-17-2014 01:06 PM
Lookup multiple values and compare different scenarios to get a specific result mws Excel 5 05-24-2014 04:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft