Quote Originally Posted by Jacc View Post
Here is a well defined problem it seems and rather interesting. Surely there are lots of people here that can handle this? I can't/don't have time/bitten of more than I can chew etc.

http://www.excelforum.com/excel-form...-criteria.html

Jacc I had a look at this and posted a solution of sorts but some of the experts may be able to refine my solution. Probably easier to do in VBA but I've crafted something that will work with formulas only.