Forum

Hi Irving, Great to see you're tackling the Power tools 🙂 Power Query is all about getting and cleaning data. Power Pivot is all about modelli...

Hi Greg, The only other workaround I could think of is to put an empty template/dummy workbook in that folder. This workbook contains the headers b...

Glad I could [indirectly] help 🙂

Hi Marilyn, Not quite, but this post might give you an acceptable solution: Mynda

Hi Marilyn, No, there's no way for Power Pivot to connect to your email. Ideally you would get the user to save the data (in an Excel, CSV or Te...

Thanks for sharing the link, Libby. It's an interesting idea but I think it should be avoided unless working with small sets of data because it's like...

Hi Libby, The short answer is there isn't a PQ formula that can replicate your IF/SUMPRODUCT since PQ can't refer to rows above/below the current ro...

Note that there are 2 buttons for finalizing an upload: -Add Files button, this will allow you to browse to select the file, and: -Start Upload ...

Hi Diane, I've removed your email address from the forum so you don't end up with a load of spam. The formula library is all online now. You find i...

Hi Nina, You have two options: 1.Create a table using formulas to return the sum of the 'period columns' for the selected part number. This tabl...

Hi Elliot, In this post under the heading "Duplicate State/City Solutions" (towards the bottom), item 4 offers a method to allow the use of the dep...

Hi Nina, It's difficult to answer without seeing your data. I don't know whether the part numbers are in the column labels or the periods. When ...

Thanks for sharing, Kim. The way I remember is that it's opposite to the alphabetical order, assuming you read left to right of course. Mynda

There is also an option to Paste as Values & Formatting in one step.

Hi Phillippe, In session 5 we look at using form controls to allow the user to choose what data they want to display in a chart. However, if you wa...