List.ContainsAny within same column

[donkey shrek]

I'm trying to check each list if any of its content matches any other lists' contents, and then flag them if found

e.g. for each List in Time
if List.ContainsAny(Current List, Any List from time column)
then flag
repeat for all lists in Time column

 

[RoryA]

What do you mean by 'flag them'?

 

[donkey shrek]

What do you mean by 'flag them'?

Maybe just adding a column, if contains any = true then “Yes” else “No”

 

[RoryA]

You could add an index column starting at 0, then use something like:

= Table.AddColumn(#"Added Index", "MatchUp", each List.ContainsAny([Time], List.Combine(List.RemoveRange(Source[Time], [Index]))))