Last seen: May 1, 2025
Okay, PQ isn't difficult to learn but it takes some effort to get started. Consider taking some of the courses offered on this site. In PQ you can g...
My assumption is that you want to identify the discrepancies between the Accounting and Bank columns. There are many duplicate numbers so it's not pos...
That's difficult to diagnose based on one picture alone. Could you perhaps share an example file with the query that doesn't give the desired result? ...
Sorry, but VBA is definitely not my thing. Perhaps someone else.
@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...