I ended my long term marriage with Microsoft Excel a number of years ago, after I retired, and am using the free Libre version instead. Lots of options are limited, but it is FREE! In the old days I would of written the entire thing in code. IN the interim there are only 2 or 3 pivots in the entire thing, and they are there only to save writing another few sumifs, or countifs, or index/match lookup tables.Pivot Tables? Man if you're not using Sort and Unique in conjunction with SUMIFS, you're not spending enough time watching the Excel championships on the Ocho...