I have a column C2:C2000 listing multiple kinds of lock systems useing abreviations. Their are only 8 or 9 different abbreviations that are repeated, but I need to show all the different kinds in cell C1. Is there a function I can use to scan the entire column and pull out one of every kind of abreviation and display it in a cell not in the actual array?