ExcelHeroThe UNIQUE function
Returns a list without duplicates.
In German Excel: EINDEUTIG
How to write it
=UNIQUE(array, [by_col], [exactly_once])- array
- The range.
- by_col
- Optional. Compare columns instead of rows.
- exactly_once
- Optional. TRUE keeps only values that appear once.
💡 The result spills into the cells below.
Try it
List each region once.
A
B
C
D
E
F
1
Region
Rep
Product
Amount
Regions
2
North
Maya
Laptop
1200
3
South
Leo
Phone
650
4
North
Leo
Phone
700
5
West
Maya
Tablet
480
6
North
Sam
Laptop
1100
7
South
Sam
Tablet
520
=UNIQUE(range) removes the duplicates.