okay, I loaded your example, have got some drop down lists for each column, but no data or formulas to SEE what you are trying to accomplish, maybe i'm missing something, but i think you'll need to talk to someone else, sorry if you feel I am wasting your time, but i have no idea what i'm dealing with here..