Excel Forum

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

Got a Question? Ask it Here in the Forum.