Extract unique values based on first 5 characters in the string

[ABSTRAKTUS]

Hello guru's,

I cannot find a solution to extract unique values from the list of products. It wouldn't be this hard if the list didn't contain many duplicates, which I want to avoid having in the result. Has anybody got an idea how to get this working? I have built a quick dummy for you to see what I'm after, as explaining the issue isn't what I'm strong at...

Dummy attached. Thanks in advance!

[KOKOSEK]

I've created something like this (picture as guide how to deal with and formulas below to paste into).
As 1st - created dynamic list which contains all matched values.
As 2nd - on list as above display unique values.

Capture.JPG

Formula of dynamic array:

Please Login or Register  to view this content.

Formula from K8:

Please Login or Register  to view this content.

[ABSTRAKTUS]

Oh, thanks KOKOSEK! A piece of art... I have managed to achieve the same result, but with a bunch of helper columns, your method is much tidier!

Thanks

[canapone]

Hi All,

I guess I'm out of time...in G8 to be copied down.


=IFERROR(INDEX(I$8:I$25,MATCH(1,INDEX((LEFT(I$8:I$25,5)=E$8)*(COUNTIF(G$7:G7,I$8:I$25)=0),),0)),"")

It should do the trick too