Forum

Hi Peter, Thanks for sharing your file. I'm not sure I follow what you want. I can see the formulas you've tried, but these don't show me what answ...

Hi Sarfraz, Yes, you can create a to-do list with Excel. You could use conditional formatting (lesson 5.13) to highlight due dates that are approac...

Hi Mesa, Welcome to our forum! Your file did not upload. After selecting the file, you need to click the 'Upload' button and then wait for the g...

Thanks for the file, but it's not clear what you want. Also, the data in the file is not in the correct layout for a PivotTable, which might be why yo...

Hi Tan, Your data is in the wrong layout which is resulting in the wrong approach. You should use Power Query to unpivot the month columns, then yo...

No, the link is explaining what a Pivot Cache is so that you have a better understanding of how PivotTables work in the background. There's no solu...

Great to hear you've found my videos helpful! You can add a calculated field and only use it in one PivotTable. However, calculated items will be a...

Hi Saliha, In Excel dates are numbers too. They're stored as date serial numbers, so it's not as simple as identifying which values are dates vs nu...

Great to hear, Alan!

Hi, Thanks for sharing your file and video explanation. Each row label in the PivotTable acts as a filter. When you have the main category field...

Hi Kent, I don't have any tutorials on that specifically, but I found this tutorial that might help. Mynda

Hi Dieneba, Thanks for sharing your file. The good news is your PivotTables share the same dataset. The issue is that you haven't connected the Sli...

Now that we have the VSTACK function we can return headers like so: =VSTACK({"Header1","Header2","Header3"...},FILTER(....your filter formula)) ...

Hi Zaki, I agree with Jessica. I'm not sure where you'd plot the line for >5 and <1 and it be clear what it represents. It would be helpful i...

Hi Dieneba, For a Slicer to be able to filter multiple PivotTables, they must all use the same source data. If you have 3 separate sources, then yo...