It can be done via an array formula, (check this link:http://www.get-digital-help.com/2009...uniquedistinct) but its probably easiest to copy the column to a new sheet then go to the Data ribbon, Data Tools group and use the Remove Duplicates function. Or use a pivot table.