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
Bookmarks