Identify condition using multiple criteria WITHOUT sumproduct?
Cool. Thanks! Really appreciate the help.
This issue I'm trying to solve is actually a small part of a much bigger
system... lots of workbooks with inter-dependencies, etc... so I'm worried
that flipping to a pivot table approach will force a re-write of the whole
thing.... which I'd like to avoid if at all possible.
|