Last seen: Aug 28, 2025
See if the attached file does what you have in mind, using size groups and a max number of 5 sizes withing each group.
I had to google a bit to find the meaning of NCMR. My guess is that you are dealing with "Non-Conforming Material Reports". Correct? It would be he...
As said earlier, then I would restructure the EOF STATUS table so that every size group has it's own row and total. Than you can use a SUMIFS similar ...
Couldn't come up with an easy formula. Actually, it's quite a monster and works only if you are using E365, 2021 or the on-line version as it includes...
I'm confident that you'll get to grips to PQ soon. Good luck!
Glad it worked. Don't hesitate to come back here in case you get stuck!
Yes now I see the screenshot better. Could it be that the From column are texts and the To column real dates left justified? When I load such a ...
Thanks for the screenshots. But I still don't understand your question or it relates to the pictures. The first and third ones seem to show exactly th...
Not really, sorry. Or perhaps I'm just slow in understanding. I attached a file with an example as 'silly' as yours. Haha! See if it makes sense. I...
Similar to the problem solved in the thread in the link below: I've adapted the solution that was provided by @Velouria in the above link ...
Can you share a file demonstrating the issue? Because when you add a column within PQ there's noting preventing you from using that custom column in a...
It took a while before I grasped your intentions. I've added some formulas to your workbook in the BOM sheet. See if that does what you need. If not, ...
Great! Well spotted. I couldn't test the code myself and forgot to add the extra parentheses.
Try by using two separate Filter steps, each testing if the parameter equals null or not. Something like this: Filter1 = if fParameters("Parameters...
I can't see what the problem is from the screenshots you provided. Could you share some proper ones (not photo's of the screen) made with the 'print s...