3 4 7 7 8 8 8 8 8 8 Band A A A B C C C E 0
3 1 3 0 1 0 0 0 0 0 Offset 1 1 1 2 3 3 3 5 ###
Distribution
A
B C D E F G H I J 13 7 7 7 20 8 7 9
A B C D E F G H I J
1 1 1 1 1 1 1 1 1 1 13 7 7 7 20 8 7 9

Hi,
Im trying with little sucess to write an procedure, that when a value "1" is
entered in the cell below the blue A, a match is performed with the "A" in
blue against the white A A A B CC....Row, for each match a formula must be
entered , in the corresponding row the "1" was entered. The same procedure
will run for B C D etc when a 1 is entered.

Many Thanks

Paul