Hi guys,
I guess I've something here to tease your brain :D

I've to analyze a sales data sheet with sales splitted per code by month.

I'd like to automatically extract the longest interval (months) of consecutive sales.

Sales from January to October

code A - 10 20 10 null null 10 15 15 15 20
code B - 90 95 null null null null null null 85 90

the formula should give 5 for the first series and 2 for the second.

help! XD