Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data
Автор: excelisfun
Загружено: 2016-08-16
Просмотров: 14445
Download Excel Files:
https://excelisfun.net/files/EMT1314....
Download File: https://excelisfun.net/
Formula from lori m at YouTube.
See Excel Formula To Create Sorted Unique List On Mixed Data:
1. (00:08) Problem set up
2. (01:26) Essential logical behind Sorting Formula
3. (04:38) Unique Count Formula For Mixed Data
4. (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.
5. (13:22) Formula to Extract a Sorted Unique List and place into Single Cells. TEXTJOIN Excel 2016 function.
Formula uses the functions: TRANSPOSE, MMULT, ROW, MATCH, COUNT, IFNA, MODE.MULT, INDEX, ROWS, N(IF,1 construction and TEXTJOIN.
lori m at YouTube posted much shorter formula (than formula 1313) with these historical notes:
1) MODE.MULT construction appears first in the Chandoo forum challenge 011
2) N(IF(1, technique is originally due to Piny on Chinese forums back in early 2011
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
