mountainman88
Board Regular
- Joined
- Jun 22, 2019
- Messages
- 109
- Office Version
- 2016
- Platform
- Windows
Per the table below I have data in a list in column A which can have the same item multiple times, I wish to generate a validation list in column C which only shows each item once (similar to remove duplicates). No VBA please, just using formulas.
Thanks!
Book2 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Data | No dupes Validation list | |||
2 | dog | dog | |||
3 | dog | cat | |||
4 | cat | duck | |||
5 | cat | camel | |||
6 | cat | owl | |||
7 | duck | ||||
8 | camel | ||||
9 | camel | ||||
10 | owl | ||||
11 | owl | ||||
12 | owl | ||||
13 | owl | ||||
Sheet1 |
Thanks!