I have a pivot table that uses custom subtotals to generate YTD and Average to Date columns. The problem is that those column headers are on a different row from the Dates column headers and I'd like to know if there is a way to combine the column headers into one row?
I'm attaching a sample...
I have a pivot table that is built off an Excel table which has calculation that display a blank cell using the double quotes "" (e.g. IF(ISBLANK(A1), "") ).
When I pivot the Excel table the pivot table returns zero where those blank cells are in the Excel table and there is no way to...
I'm trying to create a dynamic range of contiguous data in an array from a non-contiguous range of cells that I can use in a named range for a chart.
The problem I'm having is removing 0's from my array so I'm only left with the relevant data I want to use in the chart.
For example in the...