Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting letters and symbols
Hi our schedule sheets now need to be encoded with a specific letter or
symbol for each possible shift. This include upper and lower case letters. and most of the symbols on the key board. Will how do I get Countif it differenciate an "A" form a "a". and will this work for symbols. thanks Zb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting letters and symbols
Try something like this:
For a list of values in A1:A1000 This formula counts the number of cells containng exactlly "A", versus "a": =SUMPRODUCT(--EXACT(A1:A1000,"A")) Does that help? *********** Regards, Ron XL2002, WinXP "Zb Kornecki" wrote: Hi our schedule sheets now need to be encoded with a specific letter or symbol for each possible shift. This include upper and lower case letters. and most of the symbols on the key board. Will how do I get Countif it differenciate an "A" form a "a". and will this work for symbols. thanks Zb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i make excel sum up the number of letters i have in a row? | Excel Discussion (Misc queries) | |||
COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL? | Excel Worksheet Functions | |||
Equation Editor overlapping symbols after edit | Excel Discussion (Misc queries) | |||
How do I add symbols above the letters? | Excel Discussion (Misc queries) | |||
Changing letters to symbols | Excel Discussion (Misc queries) |