Example of: find a (error response) character in a column, use of a
"dead-zone" area, show quantity of "X" 's

=HYPERLINK(IF(AND(
ISNA(INDEX(ROW($BU$175:$BU$883)-ROW($BU$175),MATCH(TRUE,EXACT($BU$175:$BU$883,"X") ,0))),
ISNA(INDEX(ROW($BU$884:$BU$1156)-ROW($BU$884),MATCH(TRUE,EXACT($BU$884:$BU$1156,"X" ),0)))),"",
"#"&CELL("address",OFFSET(INDIRECT(SUBSTITUTE(SUBS TITUTE(CELL("address",$AV13),"$",""),ROW(),"")&IND EX(ROW($BU$175:$BU$1156),MATCH(TRUE,EXACT($BU$175: $BU$1156,"X"),0))),$Z$3,0))),
IF($DD$14<"0 top",IF(AND(
ISNA(INDEX(ROW($BU$175:$BU$883)-ROW($BU$175),MATCH(TRUE,EXACT($BU$175:$BU$883,"X") ,0))),
ISNA(INDEX(ROW($BU$884:$BU$1156)-ROW($BU$884),MATCH(TRUE,EXACT($BU$884:$BU$1156,"X" ),0)))),"",
INDEX(ROW($BU$175:$BU$1156),MATCH(TRUE,EXACT($BU$1 75:$BU$1156,"X"),0))),"delist'd"))