Get unique values from a 2d range?

[spacely]

Hi all,

I'd like to extract a list of unique values from a 2D range. So, text values from A1 to D10, some repeat. And in another column vector are listed just the uniques. I browsed here, but they cover uniques from just one column, not a range:

3 Ways to extract unique values from a range in Excel - Listen Data

Somehow I think one could tweak that?

Thanks!

David

 

[seba64]

Application.Transpose(arr)
This function really exists?

 

[igold]

Is this a trick question...


All you had to do was to create the ("A1:D10") range, populate it with some data, some of which was duplicated, and run the code for yourself.

That probably would have been the best approach.

 

[Rick Rothstein]

Application.Transpose(arr)
This function really exists?

Actually, it is a method of the WorksheetFunction object which is, in turn, a property of the Application object. You could write it as Application.WorksheetFunction.Transpose(arr), but VBA appears to recognize that WorksheetFunction is implied when you specify one of its members and, thus, allows you to shortcut the statement using just Application.Transpose(arr) by itself. Alternately, you can omit the Application object reference by specifying the WorksheetFunction instead; hence, it could have been referenced using WorksheetFunction.Transpose(arr) as well.

 

[seba64]

Is this a trick question...


All you had to do was to create the ("A1:D10") range, populate it with some data, some of which was duplicated, and run the code for yourself.

That probably would have been the best approach.

It's a serious question. Last month I searched for a transposition function on many websites, and all I found was function with for syntax. When I saw this post, I make a try, but the error message says unknown function