Last seen: Jun 14, 2025
@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...
@dave_uk Glad I could help
@dave_uk I believe you need the MAX of two MAXIFS and the MIN of two MINIFS. I've added them to your file. Note that I prefer to work with structure...
@hutchdjr How exactly? Numbers in one column and the codes in the next column filled down, or just in the same row? Perhaps the attached file will...
@erik_h_dk Glad i could help!
@kasey OK, so you want the total realised (sell) and unrealised (no sell) results. Then I suggest you insert a column that calculates the quantity ...