怎样统计excel单元格中某字符串的个数?
比如单元格ATCAGCACCATCAGCACCATCAGCACCATCAGCACCATCGCA中含有ATCAGCACC的个数,
实际答案为4.

假如要查找的单元格为A1,
则公式为: =(len(A1)-len(SUBSTITUTE(A1,"ATCAGCACC","")))/len("ATCAGCACC")

 

共有 0 条评论