it would seem to me that just listing the acceptable combinations would be better
If I've understood what Paul means by acceptable combinations, my 6.25 million rows are the acceptable ones, the macro has excluded some 13 million already!
What on earth can a human do with more than 6 million rows of data - I'd have difficulty handling 10 rows!
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.