Excel Forum
Similar Content
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
Excel VBA - Create an Array - 3 ways
Tutorial: Ill show you three different ways to create an array in Excel VBA and Macros and how to ge...
Make Your Macros Available in All Workbooks in Excel
Tutorial: In Excel, you can make it so all of your macros can be easily accessed by any Excel work...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)


See how to:
1)Extract a unique list of records with a formula and display in a column using the functions IF, ROWS, INDEX, SMALL, FREQUENCY, MATCH, ROW, SUMPRODUCT and COUNTIF.
2)Extract a unique list of numbers only with a formula and display in a column with the extra function ISNUMBER.
3)Extract a unique list of words only with a formula and display in a column with the extra function ISTEXT.
4)Extract a unique list of records with a formula and display in a row (requires the additional function TRANSPOSE to deal with the fact that the FREQUENCY function delivers a vertical array and we need to have it orientated horizontally (in a row).

Also see this related videos:
Excel Magic Trick 362: 12 Amazing Counting Formulas
Excel Magic Trick 368: Count Unique Items With More Than One Criteria
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula
Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
Highline Excel Class 36: Array Formulas Basics

Aladin from Mr Excel Message Board





Got a Question? Ask it Here in the Forum.