I tell you what, you guys are just awesome.

That must have took some time to sort out and you did it for no other reason tham to help another excel enthusiast


I've had a look at both solutions and as far as I can tell they seem to work so many thanks for that.

My problem now is understanding what you did and adjusting it to the actual working databases.

Normally I can figure it out but these formulaes are way above what I have done in the past. It's made me feel a little inadequate if I am honest LOL.

I'll keep trying to figure this out but if anyone of you kind souls can spare the time I have uploaded the actual database format.

Hopefully one of you can set it up for me so I'll be able to start using it Monday and save my team and I alot of wasted time.

Moving forward I want to study what you do and gain more of an understanding of some of the terms you used so hopefully I can get my head around it and do it myself next time.

If it is too much work, I completely understand. I am grateful for the effort you guys have already put in.

Database problem full.xlsx


Sincerely

Martyn