Unique values for multi column listbox

[chris01395]

I have below code which works great (thanks Jacob Hilderbrand) for a single column, but I would like to return unique values from 2 columns, and seems it is not as easy as changing range from G2:G50 to G2
:H50

As example of what I want to achieve below is source data;

Column G	Column H
Apple	Red
Apple	Green
Apple	Green
Grapefruit	Pink
Grapefruit	Pink
Apple	Pink
Apple	Green

I then want the list box to show only unique combinations;

Apple	Green
Apple	Pink
Apple	Red
Grapefruit	Pink

Order is not important.

Here is the code I have for single column;

Please Login or Register  to view this content.

Any help/guidance would be greatly appreciated.

[mohadin]

Deleted
Mac issue
Sorry

[torachan]

It works but is cumbersome using a hidden helper sheet.
Really needs arrays to replace helper sheet.
torachan.