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
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.

JMB17

Bronze Contributor

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
Copper Contributor
Aug 14, 2020
can't believe, it works. Tks so much sir. Have a good day! JMB17
- JMB17
  Bronze Contributor
  Aug 14, 2020
  You're welcome and have a good day as well.

Forum Discussion

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

Resources