Forum Discussion

Derek275's avatar
Derek275
Copper Contributor
Aug 14, 2020
Solved

How to filter whether a cell is contained in other cells？

Hi There,    I am sorting out more than one thousand phrase information. Since the information is obtained in batches, I have to filter them to ensure that they are unique. They are not repeated, b...
excel
  • JMB17's avatar
    JMB17
    Aug 14, 2020

    Derek275 

     

    I think you could try Countif with wildcards at the beginning, end, and between words. Say the descriptions are in B2:B4, then

     

    =COUNTIF(B$2:B$4,"*"&SUBSTITUTE(B2," ","*")&"*")

     

    and filter or look for items >1. Of course, make sure your workbook/data is backed up.

Derek275's avatar
Derek275
Copper Contributor
Aug 14, 2020

can't believe, it works. Tks so much sir.  Have a good day! JMB17 

JMB17's avatar
JMB17
Bronze Contributor
Aug 14, 2020
You're welcome and have a good day as well.

Resources