Hello,

This is what I am trying to accomplish:

This is the data that I already have:

Masters
A B C
BVN 1 9
EEP 1 -5
ENB 1 -6
IMO 1 0
KMR 1 -5
MMP 1 0
PKX 1 -6
PTR 1 3
SSL 1 2
SYT 1 3
YZC 1 -1
BTI 2 -3
CAJ 2 -3
HMC 2 -1
AEG 3 0
BAM 3 -7
BBVA 3 0
BNS 3 -1
BPO 3 4
CIB 3 3
CM 3 2
CNA 3 5
HDB 3 5
ING 3 0
PUK 3 7
SLF 3 2
WBK 3 1
AME 4 4
CNH 4 4
CRH 4 6
CUK 5 -1
LUX 5 -2
WPY 5 2
STM 6 -5
TSU 6 1
TU 6 -1
WIT 6 3

Slaves
D E F
ABX 1 -3
AGU 1 -3
APA 1 1
APD 1 -1
AU 1 -1
BBL 1 2
BHP 1 3
CCJ 1 -1
CNQ 1 -1
DNR 1 1
DO 1 0
EOG 1 -1
EP 1 3
EPD 1 4
ETP 1 3
GFI 1 -3
GG 1 -2
KMP 1 3
MRO 1 -2
MUR 1 -1
NBL 1 1
NXY 1 -1
OXY 1 -2
SLB 1 1
STO 1 1
SU 1 -2
TLM 1 -1
TOT 1 1
VALE 1 4
WMB 1 3
DEO 2 3
FMX 2 3
TM 2 1
AXP 3 0
BBD 3 -1
BCS 3 0
BEN 3 1
BMO 3 2
BXP 3 -1
C 3 -1
CS 3 1
GS 3 -1
HIG 3 -2
IBN 3 -3
ITUB 3 -3
JPM 3 0
KIM 3 -2
L 3 1
LNC 3 -3
MAC 3 2
MET 3 -1
MFC 3 -1
MS 3 -1
PLD 3 -3
RY 3 3
SPG 3 2
STD 3 -5
STI 3 -1
TD 3 1
UBS 3 -1
VNO 3 -3
WY 3 -1
CX 4 0
DE 4 -3
ETN 4 -3
HON 4 -4
IR 4 -3
ITW 4 -1
PH 4 0
ROK 4 1
SWK 4 -1
CCL 5 1
CNI 5 0
CP 5 0
FIS 5 1
M 5 -1
MAR 5 -1
MHP 5 1
ACN 6 -1
AMX 6 -1
CTSH 6 0
INFY 6 2
KLAC 6 2
NTAP 6 -1
TXN 6 1



The new columns should look like this:

BVN 1 9
ABX 1 -3
AGU 1 -3
EOG 1 -1
CNQ 1 -1
CCJ 1 -1

EEP 1 -5
EPD 1 4
APA 1 1

ENB 1 -6
EP 1 3
ETP 1 3

KMR 1 -5
BBL 1 2
BHP 1 3

PKX 1 -6
WMB 1 3
KMP 1 3

PTR 1 3
GFI 1 -3

SSL 1 2
SU 1 -2

SYT 1 3
TLM 1 -1
GG 1 -2

YZC 1 -1
STO 1 1

-The rest
VALE 1 4
DNR 1 1
NBL 1 1
SLB 1 1
TOT 1 1
APD 1 -1
AU 1 -1
MUR 1 -1
NXY 1 -1
MRO 1 -2
OXY 1 -2

Explanation:

Column B and E must match
Column A (bold) are the "masters" and D are the "slaves"
Every master has to have slaves below him to equal to 0. The slaves can be random, as long as B and E match.

The rest of the slaves also equal 0 and have to be displayed below.

Hopefully it is all clear and some Excel genius can solve this problem!