Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range

Download Excel Start File https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT759-760.xlsx Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm See how to create a Sorted Unique List Of Words With Formula using INDEX, MATCH, COUNTIF functions and Comparative Operators. Learn about using the INDEX function and Defined Names to create a dynamic range so that the formula will pick up any new names added to list and automatically re-sort the unique list. Array Formula. Also see the REPT function. Sort List With Formula and Remove Duplicates. Richard Schollar at Mr Excel Message Board Posted This Amazing Formula