No need to panic people. I think I solved the problem, through 2 pivot table a couple of IF statements and a little creativity.!