See Excel Formula To Create Sorted Unique List On Mixed Data:
(00:08) Problem set up
(01:26) Essential logical behind Sorting Formula
(04:38) Unique Count Formula For Mixed Data
(08:27) Formula to Extract a Sorted Unique List and place into Multiple Cells. Including the MODE.MULT function, IFNA function and an array constant with double zero in the match_type argument for MATCH to reduce a list of relative positions with errors down to a single list.
(13:22) Formula to Extract a Sorted Unique List and place into Single Cells. TEXTJOIN Excel 2016 function.