Searching multiple worksheets for different numbers simultaneously in Excel

KennyK360 , glad to help

KennyK360 

Not sure I understood what is required. Do you mean something like

=LET(
    Num, C1,
    All, {53,71},
    Factors, FILTER(All, MOD(Num, All) = 0),
    IFERROR( TRANSPOSE(Factors), "" )
)

?

KennyK360 

That could be like

function main(workbook: ExcelScript.Workbook) {

    const range = workbook
        .getActiveWorksheet()
        .getUsedRange()

    const nRows = range
        .getRowCount()
    
    let j = 0;
    let nErrors: number[] = [];

    for( let i = 0; i < nRows; i++) {
        if ( range
                .getRow(i)
                .getValueTypes()
                .toString()
                .includes("Error")
        )  nErrors.push(i) 
    }

    nErrors.map( x => {
        range
            .getRow(x - j)
            .getEntireRow()
            .delete(ExcelScript.DeleteShiftDirection.up);
         j++
    } )
}