How i count cells that includes a specific text?

  • Thread starter Thread starter Excadrix
  • Start date Start date
E

Excadrix

Hello everyone... I have this problem and i cant find a solution...

I have a list like the following

Comedy
Action / Drama / Animation / Sci-Fi
Crime/Action/Thriller
Adventure / Animation / Comedy / Fantasy
Drama
Action / Drama / War
Comedy / Family
Action / Comedy / Thriller / Crime
Action / Thriller
Drama / Action / War
Drama / Thriller / Action / Adventure / Horror
Action / Adventure / Fantasy / Crime / Romance / Thriller
Action / Adventure / Drama / Romance
Drama
Drama
Action / Sci-Fi / Horror
Action / Thriller / Horror

(every line is a cell )

my problem is that i want to count how many cells have the word pe
example "Action" in them.... is any way to do it?

Thanx in advance...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filename too long to delete file 2
Help: Using Multiple Checkboxes in a Checkboxlist to filter results in a gridview in ASP.NET 2.0 0
dropdownlist and linking help needed. 2
SUBFORMS: Adding a Third Table Isn't Successful 30
Bargain 50 games for £50, proceeds go to charity 0
Count cells containing specific text 4
listbox help needed 1
how do i automatically archive old cell contents to a separate . 1

Back
Top