Excel Forum



Excel Magic Trick 435: Extract Duplicate Records with Formula


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.





Got a Question? Ask it Here in the Forum.