shan
12-17-2015, 11:00 PM
Hello Everybody,
Good Morning!!
I am looking for a macro which will combine the data available in 3rd and 4th Column if conditions satisfied for 1st and 2nd Column.
Below Input and Output data for your reference..
INPUT
KM
Leg
Org
Dest
2,019,769,184
1
BOM
DEL
2,019,769,184
2
DEL
BLR
2,019,770,095
1
BOM
MAA
2,019,770,675
2
MAA
DEL
2,019,770,213
1
SXR
IXJ
2,019,770,213
2
IXJ
DEL
2,019,770,213
3
DEL
BOM
2,019,770,213
4
BOM
SXR
2,019,770,816
2
DEL
MAA
2,019,770,816
3
MAA
IXC
OUTPUT
Rule
KM
Leg
Org
Dest
OUTPUT
2,019,769,184
1
BOM
DEL
BOM - DEL - BLR
KM are same for Leg 1 & 2 hence Org and Dest combined in column E
2,019,769,184
2
DEL
BLR
2,019,770,095
1
BOM
MAA
BOM - MAA
KM is only one and not matching with any one hence Org and Dest taken as it is in column E
2,019,770,675
2
MAA
DEL
MAA - DEL
KM is only one and not matching with any one hence Org and Dest taken as it is in column E
2,019,770,213
1
SXR
IXJ
SXR - IXJ - DEL - BOM - SXR
KM are same for Leg 1, 2, 3 & 4 hence Org and Dest combined in column E
2,019,770,213
2
IXJ
DEL
2,019,770,213
3
DEL
BOM
2,019,770,213
4
BOM
SXR
2,019,770,816
2
DEL
MAA
DEL - MAA - IXC
KM are same for Leg 2 & 3 hence Org and Dest combined in column E
2,019,770,816
3
MAA
IXC
2,019,770,800
6
KLH
BOM
KLH - BOM
KM is only one and not matching with any one hence Org and Dest taken as it is in column E
Thank You,
Shan
Good Morning!!
I am looking for a macro which will combine the data available in 3rd and 4th Column if conditions satisfied for 1st and 2nd Column.
Below Input and Output data for your reference..
INPUT
KM
Leg
Org
Dest
2,019,769,184
1
BOM
DEL
2,019,769,184
2
DEL
BLR
2,019,770,095
1
BOM
MAA
2,019,770,675
2
MAA
DEL
2,019,770,213
1
SXR
IXJ
2,019,770,213
2
IXJ
DEL
2,019,770,213
3
DEL
BOM
2,019,770,213
4
BOM
SXR
2,019,770,816
2
DEL
MAA
2,019,770,816
3
MAA
IXC
OUTPUT
Rule
KM
Leg
Org
Dest
OUTPUT
2,019,769,184
1
BOM
DEL
BOM - DEL - BLR
KM are same for Leg 1 & 2 hence Org and Dest combined in column E
2,019,769,184
2
DEL
BLR
2,019,770,095
1
BOM
MAA
BOM - MAA
KM is only one and not matching with any one hence Org and Dest taken as it is in column E
2,019,770,675
2
MAA
DEL
MAA - DEL
KM is only one and not matching with any one hence Org and Dest taken as it is in column E
2,019,770,213
1
SXR
IXJ
SXR - IXJ - DEL - BOM - SXR
KM are same for Leg 1, 2, 3 & 4 hence Org and Dest combined in column E
2,019,770,213
2
IXJ
DEL
2,019,770,213
3
DEL
BOM
2,019,770,213
4
BOM
SXR
2,019,770,816
2
DEL
MAA
DEL - MAA - IXC
KM are same for Leg 2 & 3 hence Org and Dest combined in column E
2,019,770,816
3
MAA
IXC
2,019,770,800
6
KLH
BOM
KLH - BOM
KM is only one and not matching with any one hence Org and Dest taken as it is in column E
Thank You,
Shan