I am seeking to find the Instance of errors in each of 60 columns of data with a variable row limit.
This formula works for me in one column:
=SUMPRODUCT(--ISERROR(INDIRECT("AX$7:AX$"&BuildLimit)))
where BuildLimit is a variable Named Constant say: 2000
I do not look forward to editing 60 formulas to adjust the Column from A:BH.
This formula works for me in one column:
=SUMPRODUCT(--ISERROR(INDIRECT("AX$7:AX$"&BuildLimit)))
where BuildLimit is a variable Named Constant say: 2000
I do not look forward to editing 60 formulas to adjust the Column from A:BH.