I am getting better, i have gone for over a month without asking for help on here!!

anyway, was hoping someone may be able to help me again.

i want to have column 'Y' equal a 1 or a zero. i want it to consider column 'X' which will have the word 'start' with several rows of different numbers underneath, followed by 'start' and more numbers, then start and so on:


col 'x'
start
0
1
0
0
0
1
1
0
1
start
1
0
0
1
start
0
1
0
start


All i want is column 'y' to equal 1 for the FIRST 1 in column 'x', all other 1 or 0 should be given a zero in column 'y'

so after running the macro, the above should look like:

col 'x' col'y'

start 0
0 0
1 1
0 0
0 0
0 0
1 0
1 0
0 0
1 0
start 0
1 1
0 0
0 0
1 0
start 0
0 0
1 1
0 0
start 0


Hope this makes sense, as it is a bit difficult to explain!!

regards, Jamie