Hi everyone.
Couldn't find an answer to this one so here goes.
This array works great to count consecutive occurrences of a negative number, but I need it to skip text values of "NA" or blank cells - essentially ignoring everything except negative and positive values.
{=MAX(FREQUENCY(IF(AE4:AE630<0,ROW(AE4:AE630)),IF(AE4:AE630>=0,ROW(AE4:AE630))))}
Any suggestions??
Thanks in advance.
williampdx
Bookmarks