Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting cells, similar values
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. |
#2
|
|||
|
|||
=COUNTIF(A1:A1000,"mytext")
-- HTH Bob Phillips "SteW" wrote in message ... 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. |
#3
|
|||
|
|||
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"? "Bob Phillips" wrote: =COUNTIF(A1:A1000,"mytext") -- HTH Bob Phillips "SteW" wrote in message ... 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. |
#4
|
|||
|
|||
Why didn't you say so.
=COUNTIF(A1:A1000,"*mytext*") -- HTH Bob Phillips "SteW" wrote in message ... 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"? "Bob Phillips" wrote: =COUNTIF(A1:A1000,"mytext") -- HTH Bob Phillips "SteW" wrote in message ... 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. |
#5
|
|||
|
|||
But it won't find helo though.
-- HTH Bob Phillips "SteW" wrote in message ... 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"? "Bob Phillips" wrote: =COUNTIF(A1:A1000,"mytext") -- HTH Bob Phillips "SteW" wrote in message ... 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. |
#6
|
|||
|
|||
How does Excel know what is *similar* to Hello? Is it Helo, Heloo, Helloo,
or Gello? Or is it none of these? -- Andy. "SteW" wrote in message ... 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"? "Bob Phillips" wrote: =COUNTIF(A1:A1000,"mytext") -- HTH Bob Phillips "SteW" wrote in message ... 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. |
#7
|
|||
|
|||
Ok, thanks fella :-)
There's no way to search for things similar to something then? "Bob Phillips" wrote: But it won't find helo though. -- HTH Bob Phillips "SteW" wrote in message ... 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"? "Bob Phillips" wrote: =COUNTIF(A1:A1000,"mytext") -- HTH Bob Phillips "SteW" wrote in message ... 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. |
#8
|
|||
|
|||
Not really, your similar is my nowhere near. You could set some rules but
that would be manual. -- HTH Bob Phillips "SteW" wrote in message ... Ok, thanks fella :-) There's no way to search for things similar to something then? "Bob Phillips" wrote: But it won't find helo though. -- HTH Bob Phillips "SteW" wrote in message ... 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"? "Bob Phillips" wrote: =COUNTIF(A1:A1000,"mytext") -- HTH Bob Phillips "SteW" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTING TEXT CELLS IN A COLUMN | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
complex fomula: counting cells that are blank | Excel Worksheet Functions | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
Counting values | Excel Worksheet Functions |