Sorted List of all Unique strings

[ElmerS]

Hi,

In the attached WB you'll find a 3X8 green matrix filled with strings.

I am looking for a Formula in order to present only the unique entries in the (Yellow) range A10:A17, preferable in Ascending sorted order .

Thanks in advance, Elm

[mrice]

Try the following event driven macro

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Open the Sheet1 tab

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

The macro will run every time a change is made to the 8 x 3 range.

[ElmerS]

Thanks for your effort.

As I wrote in my first post - I'm looking for a Worksheet formula (Function) in order to achieve the task.

I'm familiar with Event-macros with loops.

If you can come up with a Worksheet formula (might be an "array formula") I will appreciate it.


Thanks, Elm.