Forum

Hi Priscilla, Thanks for sharing your file. There's nothing in the query that's obviously causing the problem. Please check the file is actually in...

Hi Thulasi, Perhaps this is what you're after. Mynda

Hi Jennifer, Welcome to our forum! This is a limitation of Power Pivot. However, you can just set up another PivotTable that shows the detailed...

Hi Thulasi, You can use the PREVIOUSMONTH function to calculate this. e.g.: =SUM(Table1[Value])-CALCULATE(SUM(Table1[Value]), PREVIOUSMONTH(...

Glad you solved it yourself, Matthew! There are tons of jobs using Excel skills. Probably easiest to do a search on Excel as a keyword on a job sea...

Hi Pieter, I'd write some VBA to insert page breaks in the Power Query output table and print that. It's already in the format you need, you just n...

Hi Pieter, You can't change the PivotTable sort order. If you don't have to print to paper, and can instead share the electronic copy of the file t...

Hi Fernanda, You could use Power Query to create a new table that merges these tables together with the final set of columns that you want in your ...

Hi Neha, Welcome to our forum. Thanks for sharing your file. Please clarify your question. You mention cell C28, but I don't know what sheet this i...

Hi Pieter, You can use a PivotTable to automatically extract the words for each student into a new sheet using this technique. Beforehand, structur...

Hi Jeana, It's not possible in Excel to restrict users to specific cells/sheets. You can use this PivotTable technique to automate the extraction o...

Hi Simon, Excel for Mac doesn't have Power Query's full functionality yet. It is currently only able to refresh connections to local Excel and CSV/...

Hi Francis, Welcome to our forum! You can select the PivotTable > PivotTable Analyze tab > Change Data Source. This will show you what it's c...

For the result in cell P4 you can use this formula: =TEXTJOIN(,TRUE,SUBSTITUTE(D5:M6,"FALSE","")) You'll have to change the cell references for ...

Hi Fernanda, The ROWS and COLUMNS functions return the number of columns in an array or reference. It's not about returning data relevant to the ce...