How to Extract unique records with an array formula in Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a group of individual rows.
Specifically, you'll find instructions on how to do each of the following:
1. Extract a unique list of records with a formula and display the results in a column using the IF, ROWS, INDEX, SMALL, FREQUENCY, MATCH, ROW, SUMPRODUCT and COUNTIF functions.
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).