True/false if list has duplicate

Lists-Logic
1

Hey All,

I’m having some hard time to figure out, I know the answer will be easy as pie :slight_smile:

I have a list and I need boolean if the sublist has duplicate element.

See image below. So if the date is there two times in sublist it should be true (or false, doesn’t matter) so I can filter sheets where revision is wrong.

Thanks :slight_smile:

date

2

You could use List.UniqueItems and List.Count and then compare the lists lengths

2 Likes
3

@daninet An illustration of the above suggestion by @Yna_Db

20170918-1
20170918-1.png990×510 39.6 KB

1 Like
4

thanks guys it worked :beer::beer:

1 Like