=INDEX(IFERROR(VLOOKUP(
ROW(A2:A25);
SPLIT(FLATTEN(IF(
REGEXMATCH(A2:A25;TRANSPOSE(B2:B25));
ROW(A2:A25) & "❤" & REGEXREPLACE(A2:A25;TRANSPOSE(B2:B25);TRANSPOSE(C2:C25));
));"❤");
2;
);A2:A25))
'user100test'.split(/(?<=\D)(?=\d)|(?<=\d)(?=\D)/g);
// [ "user", "100", "test" ]
let row = names.map((row) => row[0]).indexOf(valToFind);
=ARRAYFORMULA(QUERY(
SPLIT(FLATTEN(B2:B6 & "♡" & C2:C6 & "♡" & D2:G6);"♡");
"select Col1, Col2, Col3, count(Col3)
where Col3 is not null
group by Col1, Col2, Col3 label count(Col3)''"
))
function onEdit(e) {
if(e.range.getRow() > 1 && e.range.getColumn() === 2){
const value = e.range.getValue();
e.range.setValue(value === '' ? '' : value * .95);
}
}
class Range
{
public int Min { get; set; }
public int Max {get; set; }
}
Range[] A;