Last seen: Jun 25, 2026
@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...
Please elaborate. What is the result you would like to see?
@navsal66 Glad I could help
@navsal66 In E5: =SUMIF($L$5:$L$10,A5&"?",$N$5:$N$10) and copy down.
@ksadowski Please see the attached example. If contains two solutions. One that works in modern Excel using the BYROW function in K1, spilling the r...
@easy-goer When you add new (sub)categories, the large pivot tables expand downward. So, you should not put anything below them when you are still ...
@kcrett Fair enough, but the neat thing about PQ is that, once properly set up, it can run without much user intervention. All the users need to know ...
@kcrett Since you mentioned PQ in an earlier post, why not use it to create the table you need? In the attached file you'll find a solution that I ...
@dwierdavidwier-com I believe you only need five rules for the entire table. No need for a set of rules for every column. The CF rules in the attac...
@dwierdavidwier-com Could you please upload your file, demonstrating the issue? Remove any confidential information but leave the structure of the w...
@troy-pudney Not sure if I've understood as the screen shot doesn't match the text in your question. B2 is empty, though B6 seems to have a date tha...