Counting cells, similar values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to get excel to count the cells in a worksheet which contain a
text similar to a value?

eg If I wanted it to count the number of cells which contains the word
"apples", but in some cells it might be spelt "aples" or "appls"?
I know in that instance I could just run a spell check, but you get the idea.
 
=COUNTIF(A1:A1000,"mytext")

--
HTH

Bob Phillips

SteW said:
Is it possible to get excel to count the cells in a worksheet which contain a
text similar to a value?

eg If I wanted it to count the number of cells which contains the word
"apples", but in some cells it might be spelt "aples" or "appls"?
I know in that instance I could just run a spell check, but you get the
Click to expand...
idea.
 
Yeah I know I can do that, but if the text doesn't match exactly what I put
in quotation marks it won't be counted. Eg If I want it to count "Hello" and
someone's input "Hello." it won't be counted. Can't I get it to count things
that are similar to "hello"?
 
How does Excel know what is *similar* to Hello? Is it Helo, Heloo, Helloo,
or Gello? Or is it none of these?
 
Ok, thanks fella :-)
There's no way to search for things similar to something then?
 
Not really, your similar is my nowhere near. You could set some rules but
that would be manual.
 
You must log in or register to reply here.

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

Using a function to count cells based on multiple criteria 1
function to use to count value 9
using duplicate function 13
Count with two criteria in a second worksheet 1
Pasting cell contents into a macro 1
Want to add value from a range and display result in a cell. 3
Count everything in a Column "except" 2
Create a text based count with criteria from two differnt workbook 4

Back
Top