Oh...I understand now. This will be pretty difficult, probably beyond my ability, given the way your data table is structured. I'm kind of busy today but I will try to take a look at it tomorrow or Friday. If I can't wrap my brain around it, I will put the word out to some other folks here and see if they can figure it out.
Alternatively, unless there is some underlying reason you have the data table set up that way, may I suggest considering a redesign. It might be possible to design it in a way in which you could get the results much more easily. Filtering or pivot tables come to mind though neither are possible the way it currently is designed.
|