Guys,
I have a column of elements (colours) and i need a formula that can bring back those elements without repetition.
For example if i have
blue
blue
yellow

i need it bring back
blue
yellow

Colours come from a dropdown list

hope you can help.

Thanks

Attached Files

Material order Sample 2.xlsx (40.0 KB, 11 views)