area 3,6,8 are in Sem 2 and Sem 5, so is it not right that sem 5 is in there?
Just to clarify, when you select sem 2, the possible area is 3,6,7,8,10 and you want your calculation to work on all of those areas, regardless of semetes right? That looks to be happening, so I'm not sure what the issue is
I think what he wants is since Sem 2 has 3, 6, 7, 8, 10 then only those Sem's which have all these area's should be shown. Sem 5 only has 3, 6, 8 and don't have 7 & 10 so it should be shown. That's what I interpreted from him post.