Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding and summing case-sensitive text
Hi all.
I need to create some formulas that count the number of a given, case-sensitive letter within a long column. To be specific, I will need formulas for finding the numbers of "a", "a1" (the 1 is coding for a reversal), "A", "b", "B", "B1", etc. I wrote (if(find("A",m1),1,0)+if(find("A",m2),1,0))+... but the FIND function, which returns that pesky #VALUE! instead of a 0 for each cell in which the given letter does not occur, messes up the summing process. Anyone have any suggestions? Much obliged! -- Jen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting - case sensitive text | Excel Worksheet Functions | |||
countif function: how to distinguish case/make case sensitive | Excel Worksheet Functions | |||
how do I get formulas to recognize case sensitive text | Excel Programming | |||
Case Sensitive w/ IF | Excel Worksheet Functions | |||
.Name case sensitive | Excel Programming |