Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I count (countif) the character: *
I have a series in excel which I retrieve over the web from another D-base.
In this d-base they use the asterix (*) to check the line if there are trouble. i must solve this problems but for my boss I need to report how many of those there are. Is there a way to use the countif (or another function) to count this occurency. Also in the same column they use other characters to sign other kinds of trouble. So those have to be counted also. This I can do. I have just problems with the character "*" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I count (countif) the character: *
If cells contain only * single character then
=COUNTIF(B1:B9,"~*") (adjust the range!) Regards, Stefi €˛Mousquito€¯ ezt Ć*rta: I have a series in excel which I retrieve over the web from another D-base. In this d-base they use the asterix (*) to check the line if there are trouble. i must solve this problems but for my boss I need to report how many of those there are. Is there a way to use the countif (or another function) to count this occurency. Also in the same column they use other characters to sign other kinds of trouble. So those have to be counted also. This I can do. I have just problems with the character "*" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Countif to count occurences of time? | Excel Worksheet Functions | |||
Describe high/low range with CountIf (ex. count if >90 and <100 | Excel Worksheet Functions | |||
... Count Function ... with any character ... | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions | |||
HOW to COUNT THE FREQUENCY of specific CHARACTER WITHIN a CELL? | Excel Discussion (Misc queries) |