The simplest way to think about SCAN is that it applies a custom calculation to each element in a range/array and returns every intermediate result it produces along the way. If that sounds abstract, ...

Once you’ve built a Pivot Table, turning it into a chart is almost too easy. Simply click anywhere inside the table, go to Insert > PivotChart, and select your preferred chart type. You’d even get a ...