hi, can anyone help me please. i have a column of numbers. every so often in the column, there is the word 'start'. the amount of numbers between each 'start' varies, but i would like to put a 1 or a 0 in the column next to each number. i would like the second highest ranking number to get a 1 and all the others to get a 0.

if the first and second numbers between two starts are equal, then i would like all numbers between the 'start' to get a 0.

for example:

start
12 0
23 0
45 0
34 1
start
23 0
34 0
45 0
56 1
68 0
45 0
34 0
45 0
start
23 0
23 0
start


I posted on here months ago and someone very kindly did an array formula for me, trouble is some of the sheets are so long now that the array takes a few minutes to work it out and load up

As always, thanks if yyou can help

regards, jamie