Dec 13 2022 10:06 PM
I would like to count the occurrence of the text string "ama" within a column, e.g.
=COUNTIF(A1:A6000),"*ama*")
However, I would also like to count other variations: amas, ama's, AMA, AMAs, AMA's
without capturing text like "Amanda" that features the string "ama".
Appreciate advice on how to approach this!
Dec 13 2022 11:23 PM - edited Dec 13 2022 11:25 PM
without capturing text like "Amanda" that features the string "ama". on my side it works
Dec 14 2022 12:21 AM
Dec 14 2022 08:45 PM