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