Forum

Thanks Catalin, I didn't realise SUMPRODUCT would work that way. It's kind of working but producing wrong values, based on sample testing. I need to d...

Oops, my bad.

Catalin, The attached is pretty much the best I can do without breaching any confidentiality that applies. The real data and system are sensitive, ...

OK, to update, I've worked out how to consolidate the dates in the second table, by modifying some of the values to a negative (based on specific rule...