Get unique values with UNIQUE
BeginnerUNIQUE is a dynamic array function that returns distinct values from a range, which makes it useful when you need a clean list from repeated transaction data. When the formula finds multiple results, Excel spills them into the cells below automatically.
UNIQUE uses this structure:
=UNIQUE(array, [by_col], [exactly_once])
The array is the range you want to scan for repeated values. For this exercise, the default behavior is enough, so UNIQUE should return each customer name once, in the order each name first appears in the log.
In this sheet, the transaction log includes repeat purchases from the same customers. Build a clean customer list in the output area by using only the customer-name entries from the log, so each name appears once.
Your task:
Enter one UNIQUE formula in A16 that returns the distinct customer names from the transaction log. Let the results spill into the cells below automatically.
Need some help?
Hint 1
The array should be the customer column only. If you select the whole table, UNIQUE will compare entire rows instead of just names.
Hint 2
You do not need the optional arguments here. Use UNIQUE with a single range that starts at the first customer name and ends at the last customer name in column B.
Get unique values with UNIQUE
BeginnerUNIQUE is a dynamic array function that returns distinct values from a range, which makes it useful when you need a clean list from repeated transaction data. When the formula finds multiple results, Excel spills them into the cells below automatically.
UNIQUE uses this structure:
=UNIQUE(array, [by_col], [exactly_once])
The array is the range you want to scan for repeated values. For this exercise, the default behavior is enough, so UNIQUE should return each customer name once, in the order each name first appears in the log.
In this sheet, the transaction log includes repeat purchases from the same customers. Build a clean customer list in the output area by using only the customer-name entries from the log, so each name appears once.
Your task:
Enter one UNIQUE formula in A16 that returns the distinct customer names from the transaction log. Let the results spill into the cells below automatically.
Need some help?
Hint 1
The array should be the customer column only. If you select the whole table, UNIQUE will compare entire rows instead of just names.
Hint 2
You do not need the optional arguments here. Use UNIQUE with a single range that starts at the first customer name and ends at the last customer name in column B.