I would like to count the number of words in a column that end with a certain letter.
Countif works fine for counting how many start with a certain letter but will not work to count words that end or contain a certain letter.
For example:
COUNTIF(A1:A11,“c.") works fine but COUNTIF(A1:A11,".c”) just gives 0.
Any ideas?
Thanks