Forum

"The GetPivotData allows me a formula outside of the pivot and if I make changes to the pivot structure it disappears." Build a separate PivotTable to...

And adding the SUM to the condition 😉

Hi Monika, Welcome to our forum! You can use this formula in cell P5: =IF(AND(P3>=$B$5, SUM($E$5:O5)<$A$5),$C$5,0) And copy to co...

Hi Lea, PivotTables don't work like that. They don't leave cells blank, they're designed to aggregate the data based on the row and column labels. ...

Hi Michelle, Welcome to our forum! The TEXTJOIN formula is joining all characters, it's just that it can't display them all in the one cell without...

Hi Justin, Thanks for sharing your sample file. The data in the file is not clean enough to work with. e.g.: Item numbers are inconsistently e...

Hi Lea, If it's a regular PivotTable then the only way to add columns that are retained by the PivotTable is to add it as a Calculated Field or Cal...

Hi Justin, Welcome to our forum. Please upload a sample file so we can see the format of your data. Mynda

Hi Ichiha, Welcome to our forum! You can use this formula where your text is in cell A1: =TIMEVALUE(SUBSTITUTE(SUBSTITUTE(A1," hours, ",":"),...

Hi Mattias, It doesn't sound like you want a weighted average, just a regular average either by day, month or year. Have you tried using AVERAGEX? ...

Hi David, Thanks for sharing the video. I've not seen that use for commodity futures before. Very interesting. I had sporadic success with it e.g. ...

Hi David, Not sure why you're using the @ sign before the ticker. You need to prefix the stock ticker with the exchange 'market identifier code' as...

Hi and welcome to our forum! It's difficult to picture what you mean without seeing an example file. If you want the spacing of lines 3-5 to remain...

Hi Mortimer, Welcome to the forum! The file you're seeing is correct. It's the same file shown in the video for lesson 3.10. Mynda

Hi Erik, Still very difficult to create an image in my head from your description as to what the issue is. Usually when dealing with sensitive data...