Hello, first sorry for not using XL2BB, my company will not allow addons. I am looking for a way to count the longest string of days I have no sales and the longest string of days I do have sales. I got the array formula correct on the non sales number of days, but cannot get the longest to work.
Here is the formula I use for longest non-sales streak: =MAX(FREQUENCY(IF($A$2:$A$50=0,ROW($A$2:$A$50)),IF($A$2:$A$50<>0,ROW($A$2:$A$50))))
Any help would be appreciated.
Here is the formula I use for longest non-sales streak: =MAX(FREQUENCY(IF($A$2:$A$50=0,ROW($A$2:$A$50)),IF($A$2:$A$50<>0,ROW($A$2:$A$50))))
Any help would be appreciated.