function for Unique values in an array

[ankita.sethi]

Hi,

I have an array called "Universe", which have duplicated values.
I am trying to write a code that gives me an array which have only unique values.

Can anyone help?

 

[GTO]

...Can you please explain the intuition behind it?What is dictionary object?What does it do?

Hi there,

As Richard seems to be away, here would be my two-cents worth...

I am not sure what you were asking as to "intuition behind it."

You will want to read the vba Help topics for Dictionary Object and Collection Object, as well as their properties and methods. In short though, the critical thing for your current issue is that the each key in a dictionary is unique. (The item for a given key is not necessarily unique.) Thus - as you see in Richard's code, after checking to see if a key already exists, he adds the key and item if it does not.

I personally remember keys and items like words and definitions in an actual dictionary. Whilst each word (key) will only appear once, several words (keys) may have the same meaning/definition (item).

I hope that helps,

Mark

 

[ankita.sethi]

yes indeed it helped!
I read about them and the code became much clearer

Thanks a lot

 

[GTO]

Thank you for letting me know that helped, and of course, you are most welcome

Happy coding!

Mark