Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
How can you convert these to array formula?
=IF(COUNTIF($I:$I, $A:A)=0, "No", "Yes")
=ARRAYFORMULA(IF(LEN(A1:A&I1:I), IF(A1:A=I1:I, "yes", "no"), ))
=ARRAYFORMULA(IF(LEN(C3:C&D3:D), C3:C&" "&D3:D, ))
Required, but never shown