• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    How do I get two pivot table column headers on same row?

    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...
  2. J

    Prevent Pivot table returning zero from table "null" calculation

    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...
  3. J

    Dynamically generate contiguous data in array for chart from non-contiguos range

    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...
Back
Top