Hello All,
I have a list of 48 000 zeros and ones (0 and 1s) (and 12 separate lists).
If there is a 1 then I will return a zero.
If there is a zero then I need to find the next 1 and return the 'distance' to that 1.
For example
1
1
1
1
0
0
0
0
1
The first zero will have to return 4, the second 3 etc.
I have tried using Match(1,[range],0) but this takes for ever to run.
I could write a udf to do this but figure that it would have to be based on a loop. Can anyone think of a clever way of doing this?
In the mean time I will implement the udf.
Thanks,
Alan.