Hello Frankfurtjoe:
Assuming your data starts in row 2, paste this formula in cell C2 and copy down. Hide column C.
Code:
=IF(A2="","",IF(COUNTIF(A$2:A2,A2)=1,COUNTIF(A$2:A$1000,"<"&A2)+ROW()/100000,""))
Paste this formula in cell B2 and copy down.
Code:
=IF(ISERROR(SMALL(C:C,ROW()-1)),"",INDEX(A$2:A$1000,MID(SMALL(C:C,ROW()-1),FIND(".",SMALL(C:C,ROW()-1)),6)*100000-1,1))
This will list those unique items in alphabetical order without duplicates.