=ArrayFormula(LAMBDA(x;y;c;filter({x\y};НЕ(ЕНД(ПОИСКПОЗ(y;c;0)))))(A2:A;B2:B;E2:E))
=QUERY({Формула_1};"SELECT Col1,Count(Col1) GROUP BY Col1 PIVOT Col2")
=ArrayFormula(5000*LAMBDA(x;x/СУММ(x))(RANDARRAY(10)))
=ln(cos(A1-(ЦЕЛОЕ(A1/(2*ПИ())))*2*ПИ()))
3,14159265358979
\D на ""
(\d+)(\d{10})\n на +7$2\n
=OR(
AND(
INDIRECT("RC";0)<>""
;INDIRECT("RC[1]";0)<>""
;INDIRECT("RC[2]";0)<>""
;INDIRECT("RC[3]";0)<>""
;INDIRECT("RC[4]";0)<>""
);
AND(
INDIRECT("RC";0)<>""
;INDIRECT("RC[-1]";0)<>""
;INDIRECT("RC[1]";0)<>""
;INDIRECT("RC[2]";0)<>""
;INDIRECT("RC[3]";0)<>""
);
AND(
INDIRECT("RC";0)<>""
;INDIRECT("RC[-1]";0)<>""
;INDIRECT("RC[-2]";0)<>""
;INDIRECT("RC[1]";0)<>""
;INDIRECT("RC[2]";0)<>""
);
AND(
INDIRECT("RC";0)<>""
;INDIRECT("RC[-1]";0)<>""
;INDIRECT("RC[-2]";0)<>""
;INDIRECT("RC[-3]";0)<>""
;INDIRECT("RC[1]";0)<>""
);
AND(
INDIRECT("RC";0)<>""
;INDIRECT("RC[-1]";0)<>""
;INDIRECT("RC[-2]";0)<>""
;INDIRECT("RC[-3]";0)<>""
;INDIRECT("RC[-4]";0)<>""
)
)