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 |
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 |
All times are GMT +1. The time now is 10:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com