Okay, so, I have a problem that has caused a bit of hair-pulling on my side, especially as all I have been able to Google results for is how to concatenate two cells with an ampersand:
Basically, I have three columns, A, B and C. These columns will contain variable amounts of data, based on the data in an entirely different sheet (which is updated every two hours, hence why I want this bit to run without any input outside of opening the sheet), and the quantity of data in each column can vary from 1 to 260 rows.
<TBODY>
</TBODY>
What I want is to end up with a single column D with all of unique values from A, B and C (column D doesn't have to be in order; this is just to help demonstrate what I want):
<TBODY>
</TBODY>
Anyone got ideas for how I can construct my formula for this?
(I got Excel 2010, btw)
Basically, I have three columns, A, B and C. These columns will contain variable amounts of data, based on the data in an entirely different sheet (which is updated every two hours, hence why I want this bit to run without any input outside of opening the sheet), and the quantity of data in each column can vary from 1 to 260 rows.
| A | B | C |
| 1 | 2 | 5 |
| 2 | 3 | 6 |
| 3 | 4 | 7 |
| 5 | 5 | |
| 7 |
<TBODY>
</TBODY>
What I want is to end up with a single column D with all of unique values from A, B and C (column D doesn't have to be in order; this is just to help demonstrate what I want):
| D |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
| 7 |
<TBODY>
</TBODY>
Anyone got ideas for how I can construct my formula for this?
(I got Excel 2010, btw)
