怎么查找excel某一单元格里的几个连续数据

发布网友发布时间：2022-05-05 00:26

共3个回答

热心网友时间：2022-06-27 18:27

在B1中输入或复制粘贴下列公式之一
=IF(COUNT(FIND(7692,A1)),A1,"")
=IF(ISNUMBER(FIND(7692,A1)),A1,"")
=IF(COUNT(FIND(7692,SUBSTITUTE(A1," ",))),A1,"")
下拉填充追问我只是想知道单元格里面有没有我想要的某几个连续数据。假如数据还是如上！但是我想查找这些数据里面没有有0880应该怎么查找呢！

追答在B1中输入或复制粘贴下列公式之一
=IF(OR(COUNT(FIND({"7692","6928","9680","0880"},A1))),A1,"")
=IF(OR(ISNUMBER(FIND({"7692","6928","9680","0880"},A1))),A1,"")
=IF(OR(COUNT(FIND({"7692","6928","9680","0880"},SUBSTITUTE(A1," ",)))),A1,"")
下拉填充

热心网友时间：2022-06-27 18:27

用自动筛选，自定义自动筛选

热心网友时间：2022-06-27 18:27

ctrl+f 输入7692？？？？？