Hi All
I have recently started using CountIf and was wondering how I could use the wildcard characters to find the number of people who's surname whose 3rd letter begins with a "n". I have been able to do this with the first name (as the first name is where the text starts from i.e. the left of the cell) but am finding it increasingly difficult to do this with the second names only.
Please see attachment (yellow highlighted cell I3) and see if you can help out if possible!
Thanks in advance for any suggestions.
Bookmarks