Hello everyone,

I have a serie of value in a column, most of these values are redundant. In another column I want each unique value.

car car
car truck
car apple
truck house
truck
apple
apple
apple
house
house

Users can add anything at the end of serie of values (in the first column), and I need right away to have the result on the second column, preferably without Macro.

Anyideas about a function that can do that?

Thanks !