I’m having an issue in excel automation for the task. I have data in Column-1(Block) and in column-2(Work code) With the data (0204003012/IF/GIS/585362) in this format. Here I need to find the columns contains /GIS/ and in the final output only the count of /GIS/. Please help me with this.
For GIS extraction.xlsx (6.7 MB)