Forum Discussion
Solved
How To Check If Column has Certain Word
Hello. In excel, I have a cell that is supposed to check if the word in a box matches one of the words in the A column. However, when I try running it, it says #SPILL! The function is: =IF(FIND(F...
Another variant is to use
=IF(SUM(COUNTIF(F6,A:A)),"Hello",B1)but from performance point of view much better to use dynamic range as
=IF(SUM(COUNTIF(F6,A1:INDEX(A:A,COUNTA(A:A)))),"Hello",B1)
Another variant is to use
=IF(SUM(COUNTIF(F6,A:A)),"Hello",B1)but from performance point of view much better to use dynamic range as
=IF(SUM(COUNTIF(F6,A1:INDEX(A:A,COUNTA(A:A)))),"Hello",B1)
SergeiBaklan Thank you, this ended up working
HaveProblemsEveryday , you are welcome
