no. of instrings

  1. H

    Find no. of repetitions of a string in a cell

    Hi, I have a text in cell H2. My sheet contains text values from A5 to A233. I need to find out how many times the text in cell H2 is being repeated in the column A. (Apparently the whole sheet excluding H2) Is there any formula where I can find out the no. of instances of an instring in a...

Some videos you may like

This Week's Hot Topics