Forum

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

Hi Steve, From what I know about the current priorities for building new chart functionality, I'd say the chances of Microsoft building a new Pivot...

Interesting...when you display both vertical axes the scale for the two series changes so that the 740 column is higher than the 795 column. I turned ...

Hi Eric, Maybe what you need to use is Power Pivot to create relationships between your tables using the Case# field. However, like Phil mentioned,...