Hi,

I was wondering if there is a formula to take a list of values and use a formula to extract a list of unique values.

See the attached spready, with column a containing a list of fruits, which includes the same type of fruit in some rows and then column E, which only contains the unique values.

Of course I can copy the values from column A into another column and then manually remove duplicates.

I was just wondering if there is a formula way to do that automatically?RemoveDuplicatesFormula.xlsx

Many thanks!

TT