Custom Collumn searching for Duplicate Values

Question

Hi all&nbsp;&nbsp;I have table collumn where it contains values such as:&nbsp;&nbsp;482932983Ryan by themselves and as the main goalkeeper482932984Tim and John by themselves and as the main strikers482932985Kepa and Ronaldo by themselves and as main players&nbsp;I am looking to grab instances where there is 2x players within the statements&nbsp;1 certainty is that there always exists 2x "and" instances if that is true.&nbsp; I am not sure how to get a custom collumn where it picks up the 2x "and" instead of just 1&nbsp;Anyone have any ideas?

anonymous · Answer

Hi&nbsp;muggydaniel&nbsp;,
&nbsp;
Please try the Text.Contains() function.

Text.Contains - PowerQuery M | Microsoft Learn&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Custom Collumn searching for Duplicate Values

1 Reply

Related content

Index multiple collumns

Duplicate ranking

Slicer Search Bar

remove duplicate value within a row

Create dashboard with many duplicate collumns

482932983	Ryan by themselves and as the main goalkeeper
482932984	Tim and John by themselves and as the main strikers
482932985	Kepa and Ronaldo by themselves and as main players