怎样统计excel单元格中某字符串的个数? 比如单元格ATCAGCACCATCAGCACCATCAGCACCATCAGCACCATCGCA中含有ATCAGCACC的个数, 实际答案为4. 假如要查找的单元格为A1, 则公式为: =(len(A1)-len(SUBSTITUTE(A1,"ATCAGCACC","")))/len("ATCAGCACC")
怎样统计excel单元格中某字符串的个数? 比如单元格ATCAGCACCATCAGCACCATCAGCACCATCAGCACCATCGCA中含有ATCAGCACC的个数, 实际答案为4. 假如要查找的单元格为A1, 则公式为: =(len(A1)-len(SUBSTITUTE(A1,"ATCAGCACC","")))/len("ATCAGCACC")
共有 0 条评论