Excel Magic Trick 1314

Array Formula To Create Sorted Unique List with Mixed Data

DESCRIPTION

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.

WORKBOOKS

Download “Excel Magic Trick 1301-1320” Excel-Magic-Trick-1301-1320.zip – Downloaded 337 times – 285 KB




Be the first to comment

Leave a Reply