I have an array of strings i need the string which is duplicate . can u give me any simple functions to achieve this.
My array would be like this {"one","two","one","three"}
Thanks
Discussion posts and replies are publicly visible
Hi
Use intersection function
=load( local!StringInput: {"one","two","one","three"}, intersection(local!StringInput,local!StringInput) )