• 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.

Recent content by JohnF123

  1. J

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

    Thanks, but unfortunately when I select additional months and the pivot table expands the shape does not move when the table expands
  2. J

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

    Hmm...That's what I thought. Thanks Jeffrey, I'll just have to keep it the way it is then.
  3. 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...
  4. J

    Prevent Pivot table returning zero from table "null" calculation

    Yes Narayan, that works perfectly. I love the conditional formatting solution. Thanks. John
  5. J

    Prevent Pivot table returning zero from table "null" calculation

    Hopefully the attached will help clarify what I'm trying to achieve. Thank you all for your help.
  6. J

    Prevent Pivot table returning zero from table "null" calculation

    Just to clarify, I don't want to filter the blanks out from the view, I want to show them as blanks and not as zeroes and still have the average calculate.
  7. 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...
  8. J

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

    Good point about the rounding Narayan. My data only has whole numbers which are being used in a chart and I don't need to have fractional accuracy, but future data sets may be used for other purposes and contain fractions, so the rounding is something to keep an eye on. Thank you both so much...
  9. J

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

    Very creative use of the small function to combine the row number as the whole number and the value in that row as the decimal portion (ROW(ValueList) + ValueList%%) so when the small function sorts the data in the array in ascending order it is sorting by row which happens to have the value...
  10. J

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

    Wahoooo!!!! That worked Sajan! Thank you so much!!! Now I have to study this and figure out how it works....I love this stuff!
  11. J

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

    Thanks Narayan, I've seen that post and studied and tried all the options recommended, but they either rely on helper columns (which is not an option for me to use), or they used the small function in an array formula which sorted the data in ascending order which is also not what I want, or...
  12. 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