INDIRECT
=MAXIFS(
INDIRECT("Sheet1!$B$2:$B"),
INDIRECT("Sheet1!$C$2:$C"), "=863705125",
INDIRECT("Sheet1!$A$2:$A"), "=7/1/2024"
)
match
является undefined
function base26ABCfrom10_(number) {
let num = number;
let sfx = '';
while (num > 0) {
const cd = (num - 1) % 26;
sfx = String.fromCharCode(65 + cd) + sfx;
num = Math.floor((num - cd) / 26);
}
return sfx;
}
const nameTo = ss.getSheetByName(name) ? `${name}_${new Date().getTime()}` : name;
sheetTemp.setName(nameTo);
if(ss.getSheetByName(name)) {
ss.deleteSheet(name);
}
if(!ss.getSheetByName(name)) {
sheetTemp.setName(name);
}