I have this formula in Excel 2003.
=MAX(FREQUENCY(IF(AM$67:AM$2001=AN4,ROW(AM$67:AM$2 001)),IF(AM$67:AM$2001<AN4,ROW(AM$67:AM$2001))))
I am trying to calculate the number of runs located in column AM. Cell AN4 equals the number 2 that I am trying to figure out occurred so many times as part of a run not the number of times it occurred using COUNTIF. I used a formula I found online that worked for them perfectly. Won't work for me. I get #VALUE! instead. What am I doing wrong? Thanks.