Have a Question?

If you have any question you can ask below or enter what you are looking for!



Count if function

I have to Count the no. of times name appearing in a Cell. Like "rohit,,,sunny,sunita,rohit,,,////(((alka,rohit" in this example i have to count rohit, how many times he is appearing in this.

  Rupesh Kumar


=(LEN(G26)-LEN(SUBSTITUTE(G26,"rohit","")))/LEN("rohit")

  sunny kumar       19 Jun 2016       1       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any