SOLVED

# Replicate a Formula in a column

Copper Contributor

# 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

2 Replies
best response confirmed by gtwomedia (Copper Contributor)
Solution

# Re: Replicate a Formula in a column

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.

# Re: Replicate a Formula in a column

@HansVogelaar Thank you that helped alot!  i forgot that \$ locks the cell choice

1 best response

Accepted Solutions
best response confirmed by gtwomedia (Copper Contributor)
Solution

# Re: Replicate a Formula in a column

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.