Re: Finding Next 1 In A List Of 0 And 1
Thanks for your suggestion.
I am analysisng 15 years of offshore wave data in 3 hourly intervals.
I thought of writing a time series analysis tool that processed it sequentially, however there are several things that I am analysing for and Excel has done very well so far. This one may be the one that makes me go back to a time series analysis tool and output the results to Excel.
However if I can avoid this I would like to...
I have written the udf and I am running it over 6 columns of data at the moment. It appears to be working but will still take a long time and therefore I may as well do a time series analysis tool...
Anyone else have an idea?