agerrard
Active Member
- Joined
- Apr 4, 2005
- Messages
- 406
Hi All,
Please see my example below:
This is my raw data.
I want to somehow get Excel to remove the duplicates and to only show all the unique values (see my example below):
I know you can remove duplicates in the data field, but i need this to be a formula as the list will change etc...
Hope this is enough info makes sense.
Cheers,
Please see my example below:
This is my raw data.
Excel 2007 | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
3 | RAW DATA | ||||||
4 | Product Name | TOTAL | SEGMENT | BRAND | CUSTOMER | ||
5 | Product1 | Total | Segment1 | Brand1 | Customer1 | ||
6 | Product2 | Total | Segment1 | Brand3 | Customer1 | ||
7 | Product3 | Total | Segment2 | Brand1 | Customer1 | ||
8 | Product4 | Total | Segment2 | Brand2 | Customer1 | ||
9 | Product5 | Total | Segment2 | Brand2 | Customer1 | ||
10 | Product1 | Total | Segment1 | Brand1 | Customer2 | ||
11 | Product2 | Total | Segment1 | Brand1 | Customer2 | ||
12 | Product6 | Total | Segment2 | Brand2 | Customer2 | ||
13 | Product7 | Total | Segment1 | Brand3 | Customer2 | ||
14 | Product8 | Total | Segment2 | Brand1 | Customer2 | ||
15 | Product1 | Total | Segment1 | Brand1 | Customer3 | ||
16 | Product2 | Total | Segment1 | Brand2 | Customer3 | ||
17 | Product9 | Total | Segment2 | Brand4 | Customer3 | ||
18 | Product3 | Total | Segment2 | Brand5 | Customer3 | ||
19 | Product10 | Total | Segment1 | Brand6 | Customer3 | ||
mapping (3) |
I want to somehow get Excel to remove the duplicates and to only show all the unique values (see my example below):
Excel 2007 | |||||||
---|---|---|---|---|---|---|---|
H | I | J | K | L | |||
3 | OUTPUT | ||||||
4 | Product Name | TOTAL | SEGMENT | BRAND | CUSTOMER | ||
5 | Product1 | Total | Segment1 | Brand1 | Customer1 | ||
6 | Product2 | Segment2 | Brand2 | Customer2 | |||
7 | Product3 | Brand3 | Customer3 | ||||
8 | Product4 | Brand4 | |||||
9 | Product5 | Brand5 | |||||
10 | Product6 | Brand6 | |||||
11 | Product7 | ||||||
12 | Product8 | ||||||
13 | Product9 | ||||||
14 | Product10 | ||||||
mapping (3) |
I know you can remove duplicates in the data field, but i need this to be a formula as the list will change etc...
Hope this is enough info makes sense.
Cheers,