List of unique values from an array

I have a large array of integer values and blanks (13000R X 67C), and I need a list of unique values to define property zones for a model. I used advanced filter, which weeded it down to about 725 unique rows, but it is still a formidable task for my staff to manually compile a list, with great potential for errors. I don't care where in the array the values are, or how many of them there are (I may want to know that later, but I more or less know how to do that). Is there a handy way to generate a list, which may contain over a thousand values, from an array without individually searching each column? I searched the forum for "unique values" topics, but didn't find exactly what I needed.

Try this macro

Please Login or Register  to view this content.

That was exactly what I needed. Thanks!