willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 886
- Office Version
- 365
- Platform
- Windows
I am hoping someone could help me with a Unique formula that makes a unique list from a range of cells (multiple columns)
Below is an example of what I am looking for however the actual data may be 30 columns and roughly 200 rows (and the columns may not be all beside each other)
Thank you very much to anyone who can help!
Below is an example of what I am looking for however the actual data may be 30 columns and roughly 200 rows (and the columns may not be all beside each other)
Thank you very much to anyone who can help!
Change Request.xlsm | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | 1 | 2 | 3 | 4 | Result | |||
2 | Blue | Yellow | Red | Pink | Blue | |||
3 | Red | Yellow | Purple | Blue | Green | |||
4 | Yellow | Green | Red | Blue | Pink | |||
5 | Purple | |||||||
6 | Red | |||||||
7 | Yellow | |||||||
Sheet2 |