Hi all,
pls. i try to search bad characters and count how many there are, but something i do wrong.
I have column with names and sometimes i have bad character in name. I know exacly which they are and try to count them in whole column.
So i need formula, which will count this character in cells. Not whole content of cell, but only concrete characters.
e.g.
i search character "X", "Y", "Z"
column A content
david
johny
xenia
linux
bradZ
x
nany
Results will be 6.
my defined range: aktual_meno, aktual_pocet
I tried this (from google) but it doesnt works.
thx for your help=SUMPRODUCT(--ISNUMBER(SEARCH("x";aktual_meno))(--ISNUMBER(SEARCH("y";aktual_meno))(--ISNUMBER(SEARCH("z";aktual_meno));aktual_pocet)