Last seen: Jul 3, 2025
@stockjam It's difficult to determine the cause of this based on a picture in a PDF only. Can you share the XLSX file, like I did earlier? Just for...
@vik Well, I would collect all data in a tabular format. For instance, a five column table with the following headers: Project, Object, Date, Amount...
@vik I believe that your set-up make matters unnecessarily complicated, but that's your choice. The attached file has the formulas that calculate th...
@vik Not sure without seeing what exactly is in the cells you reference but your original formula doesn't seem to make sense. Perhaps this one does ...
@phil1961 The template you are using (Mynda's) has rectangle shapes that contain the references to individual cells inside pivot tables. Such shapes...
@phil1961 Don't really know! Inserted the split screen again and can still insert a row where I want. Would need a step-by-step guide on what you did ...
@phil1961 Removed the screen split and the filter on the table. You have 460 empty rows in there. Removed them as well and can insert a row anywhere I...
@stockjam Attached workbook contains one way to deal with it. The query is quite crude but works for a relatively straight-forward task like yours. ...
@navsal66 OK, being new to PQ is somewhat of a challenge. All the steps are listed in the “Applied steps” list. Most are done by clicking in the User ...
@navsal66 OK, understood. Then perhaps a very crude query does what you need. Most likely it can be optimized, but for now it works. The trick is t...
@navsal66 Don't understand. You highlighted one entry with multiple invoice numbers and one total value. Beside the table, you split the total into ...
You must have set the worksheet to "Show Formulas" by accident. Press the icon on the Formulas ribbon and your problem will be solved.
@dwierdavidwier-com Had a look at your previous file where the “Applies to” range was $B$4:$F$274 for all rules. Now, let’s assume you want to app...
@navsal66 If I remember correctly you are using E2019. Then you are bound to use some helper columns that determine the 'group number' for each invo...