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.