I have an array formula, i think that's what it's called - that finds the most frequent word in a column and returns it while simultaneously ignoring the blank cells and it works totally fine. My problem is when i try to copy it to the next column, the formula stays static, meaning if it's a formula for column C, but now i paste the formula in column D - then hit ctrl+shift+enter it still says column C, so I have to manually type in all of the references to column C and change them to column D to make the formula work in that column. I did it for 5 columns manually and I'm spent. Is there a way I can make this auto populate the new column? Here is my formula:

=INDEX($C$4:$C$33,MATCH(INDEX(MAX(COUNTIFS($C$4:$C$33,$C$4:$C$33,$C$4:$C$33,"<>0"),),),INDEX(COUNTIFS($C$4:$C$33,$C$4:$C$33,$C$4:$C$33,"<>0"),),0))