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