Last seen: Aug 23, 2025
@prof_fr Much improved, though I couldn't resist helping out a bit more. In the attached file I cleaned up the invalid/incorrect named ranges and a...
@prof_fr The file contains many invalid and incorrect named ranges. Each column in the new learner sheet is formatted as a separate table, though I ...
@stockjam Just thought of a more effective solution. Similar to the one mentioned above, but with more condensed grouping after realising that you don...
Indeed, you cannot add calculated items to a Power Pivot table. If it's just the bottom line you want labelled "Surplus/Deficit" why not just replace ...
@robbieg You can use last optional argument of the SORT function to indicate that the data is in a row across columns.
When you have split the data, the second column [Price Raw] contains null for all rows where the region name is in the first column [Item]. So, add a ...
I've moved your question to the Dashboards & Charts forum! Please upload your file so that we can see what you have already done. And then we do...
In D1 you can enter: =COUNTIF($C$3:C4,C4) and copy it down. That will do exactly what you need.
May I assume you are working on Mynda's Ultimate Personal Budget template? In any case, please upload your file so that we can see what exactly you ar...
The attached file contains a solution that may work for you, though it requires a modern Excel version. I changed column B on the MASTER to display on...
@v-r_tayloryahoo-com Regarding 1, I've added a named formula TOselection and referenced it in J1 as the source of the TO_value. Don't need the extr...
Sure! Attaching the file with the formula in it and custom formatted [hh]:mm
@v-r_tayloryahoo-com I looked at the file but don't understand what the problem is. could you please elaborate?
You may use SUM as usual, but must custom format the cell as [hh]:mm The square bracket turn clock-time into a duration of 101:35. Omitting this ste...
@ingaiyoung Great that you resolved it yourself, though I would still like to share two other solutions. The first considerable boosts performanc...