i have a column where i am counting the word HUD in each cell. unfortunately in some cells it can appear 2 or 3 times. is there a way to count it only once per cell (if it occurs of course)?
i currently am using =COUNTIF(A:A,"*HUD*"). i am very new at this. any help is very much appreciated.