How many cells are there in B column where sentence ended with text "CP". I put formula RIGHT(text,[num_chars]) in C column then Countif with criteria "CP" and get the problem solved.
But I'm seeking the solution in a cell which will bring result from Column B.
Any formula?
Thanks in advance
Bookmarks