| View previous topic :: View next topic |
| Author |
Message |
thepletts
General User
Joined: 17 Feb 2004
Posts: 11
|
 Posted: Sat Feb 19, 2005 1:01 pm Post subject: case-sensitive COUNTIF? |
 |
|
Is there some way of making COUNTIF case-sensitive?
For example, in a monthly work schedule, I'd like to count the number of "d" (7.5 hour shifts) and "D" (11.25 hour shifts) separately.
Thanks much,
Daniel |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8979
Location: Lexinton, Kentucky, USA
|
| Posted: Sun Feb 20, 2005 8:37 am Post subject: |
|
|
I can't figure out how to distinguish between upper and lower case even when using hex notation. Might I suggest using Find and Replace set to Match Case to change "d" to "dd" then you can do it with:
COUNTIF(A1:A5;"dd$") and "d$"
This answer assumes you have only "d" and "D" in the column.
BTW, I will be posting a much faster version of the ASCII conversion macro today or tomorrow if you are still using it. |
|
| Back to top |
|
|
|
