Excel Forum
Similar Content
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Filter Results in Excel to Show Only Those that End With Specified Text or Words - AutoFilter
Macro: This free Excel macro filters data to display results that end with certain words, text, o...
Require a Unique List of Numbers in a Range in Excel
Tutorial: I'll show you how to require a user to enter a unique number into a range of cells in Exce...



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.