Keyboardist
Board Regular
- Joined
- Mar 2, 2016
- Messages
- 54
I know this is a simple task, but I'm having trouble.
I need to combine A & B with C & D into E & F without duplicates.
Below is what I'm trying to do
<tbody>
</tbody>
I am continually changing A-D, so the formula in E & F needs to update with that.
I need to combine A & B with C & D into E & F without duplicates.
Below is what I'm trying to do
A | B | C | D | E | F |
AMN | 2.09 | APH | 16 | AMN | 2.09 |
APH | 11.08 | DG | 14 | APH | 27.08 |
ENDO | 28.75 | GTC | 17 | ENDO | 28.75 |
FRAM | 20.05 | HSH | 7 | FRAM | 20.05 |
LDO | 6.10 | LDO | 23 | LDO | 29.10 |
<tbody>
</tbody>
I am continually changing A-D, so the formula in E & F needs to update with that.