|
|
Featured Tutorial
Featured Macro
Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range
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
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