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

    What data is feeding a Pivot Table

    I have a pivot table in a model that has been set up by a consultant who predictably has now taken his fee and buggered off. Where do I click on the existing pivot table to definiatively prove what table of data is feeding it please?
  2. JJ

    iPad Excel File Handling

    I have just started the frustrating journey of using Excel for iPad. I have successfully saved a couple of files on to my iPad (not Onedrive). Now I wish to delete one of them. How do I do that please? Secondly is there a way of overwriting and an existing file when you go to save please? Again...
  3. JJ

    vlookup, range name is in a cell, not directly in the formula

    I have set up a vlookup like this: =VLOOKUP($C11,DGPlus,H$2,FALSE) (which works) As per best practice the range that is being looked up is in a named range called "DGPlus". (and the lookup value is in column $C, and the lookup column number is in row $2) Now I want to have a series of vlookups...
  4. JJ

    Icon sets Conditional Formatting - Trouble with the Pie [SOLVED]

    I am building a visual strategy template, and one of the visuals is a pie in which you fill in the quarters as the project progresses. Luckily this in one of the new Icon Sets in the new Excel conditional formatting. The problem is that I am having trouble with the pie one I need. I have set...
Back
Top