|
|
#2
05-01-2021, 04:08 PM
|
||||
|
||||
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. 
|
|
|
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 & 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 |
|
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 |
Windows 10 
Office 2019
Threaded Mode