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

Published November 29, 2012 | By Bman

Download file: people.highline.edu 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
Video Rating: 4 / 5

Posted in Making Movies | Tagged Array, Duplicates, dynamic, excel, formula, List, Magic, named, range, Remove, sort, Trick