Excel Magic Trick 435: Extract Duplicate Records with Formula
Online Courses for microsoft excel :
Course updated 2009-11-02 17:47:34
Instructor : ExcelIsFun
Course Duration : 5:54
Rating : 4.81 / 5
Step by step & Descreption :
See how to take duplicate records listed vertically and list them horizontally using an array formula. See the functions: COUNTIF, IF, COLUMNS, INDEX, SMALL, ROW functions.