Hi,

There are 10 different possibilities for A1, some may have 2 and others 3 conditions so possibly up to 30 conditions.

Its trying to figure the formula etc then its a "data entry" task to do all of the formulas.

Really appreciate your help on this.