Excel: Counting cells which contain one (or more) specific strings
I’m using Excel 2016, and I have a dataset with a large number of strings, and I need to find out how many cells in a given range (‘Geotech Data’!G:G in this case) there are that contain one of 29 different strings (CPT, DCP, Soakage, Clegg, Seismicity, etc.).