v
Size: a a a
v
A
A
v
K
v
A
=ЕСЛИ(A7:A<>""; МАКС(ЕСЛИОШИБКА(QUERY($A$5:$C;"select A where C contains '"&C7&"' ");0));"")
ИР
A
ARRAYFORMULA()
A
ИР
ᅠᅠ
G
=ЕСЛИ(A7:A<>""; МАКС(ЕСЛИОШИБКА(QUERY($A$5:$C;"select A where C contains '"&C7&"' ");0));"")
G
K
=ARRAYFORMULA(ЕСЛИ(REGEXMATCH(TO_TEXT(A2:A11);JOIN("|";to_text(ВПР(UNIQUE(B2:B11);QUERY({СТРОКА(A2:A11)\A2:B11 }; "SELECT Col3,Col2 ORDER BY Col1 DESC ");2;0))));A2:A11;))
A
=ARRAYFORMULA(ЕСЛИ(REGEXMATCH(TO_TEXT(A2:A11);JOIN("|";to_text(ВПР(UNIQUE(B2:B11);QUERY({СТРОКА(A2:A11)\A2:B11 }; "SELECT Col3,Col2 ORDER BY Col1 DESC ");2;0))));A2:A11;))
A
A
K
=ARRAYFORMULA(ЕСЛИ(REGEXMATCH(TO_TEXT(A2:A11);JOIN("|";to_text(ВПР(UNIQUE(B2:B11);QUERY({СТРОКА(A2:A11)\A2:B11 }; "SELECT Col3,Col2 ORDER BY Col1 DESC ");2;0))));A2:A11;))