Get List of Sorted Unique Codes Excluding Errors & Blanks in #Excel 365=SORT(UNIQUE(TOCOL(B6:D14,3)))