So is the code entered as a Change Event (Private Sub)? I like to
avoid using VBA as the solution but if that's the only way that's
fine. I have approximately 150 rows/ items. The recap area will have
a lot less items listed; maybe 20 or so. The workaround I have is to
have each row in the recap area with this formula, =IF($O6=
$Q6,$A6,""). But I want to avoid having a 150 row recap area with
only 20 items scattered all over the place. I thought using an array
formula would be the best solution in which I could condense the recap
area with "out of spec items" on one single page (or so).
Thanks,
J