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
