Forum Discussion
Replicate a Formula in a column
I think this is simple but i can not remember how to do it
I need to replicate a formula in all cells in column B so that if a word in a2:a13 appears in column K... then column B... is filled with true
Formula
=OR(COUNTIF(K9,"*"&A2:A13&"*"))
I thought is was shift or cntl + down arrow but that is not working
When I drag th botton right dot, it changes the a2:a13 values
Use
=OR(COUNTIF(K9,"*"&$A$2:$A$13&"*"))
or
=OR(ISNUMBER(SEARCH($A$2:$A$13,K2)))
and confirm by pressing Ctrl+Shift+Enter if you do not have Microsoft 365 or Office 2021.
2 Replies
Use
=OR(COUNTIF(K9,"*"&$A$2:$A$13&"*"))
or
=OR(ISNUMBER(SEARCH($A$2:$A$13,K2)))
and confirm by pressing Ctrl+Shift+Enter if you do not have Microsoft 365 or Office 2021.
HansVogelaar Thank you that helped alot! i forgot that $ locks the cell choice
