hi ,i have attached a workbook with 2 examples,i have a formula at D1 which counts a certain event at C:C and at H1 which counts the numbers 1,2 at G:G.what i need is to make one formula which states that : if the last 2 nubers and the sixth and seventh and same with the eleventh and twelveth number(from below) are the same value and order and the 3,4,5 with the 8,9,10 numbers are also the same value and order count 12.i need only one formula to count everything .thanks
Bookmarks