checking for a string & No.
Hi David,
Pls refer the below example,
ABC
ABC
CDE
EFG
EFG
ABC
I have some data's in a col as mentioned above. Now i use countif to count
the values. I want to count only "ABC" in that Col and subtract with the
total no. of Rows and reject some values in that col.
Refer the detail explaination below,
I have totally 6 rows.
"ABC" = 3,
"CDE" = 1,
"EFG"=2
I want to know the count of
= Total (6 rows) that does not includes "CDE" - "ABC"
Ans : (6 - 1) - 3 = 2
Pls help me how to calculate this............
Thanks in advance.
-Christ
"David Biddulph" wrote:
=LEN(A2)-LEN(SUBSTITUTE(A2,"A",""))
--
David Biddulph
"Christopher Naveen" wrote in
message ...
... Also pls tell me how can we find that how
many A's i have in a cell,
Ex :
AAAABBN
AHHH
AQREE
AA
....
|