i want to find out duplicate stocks in 2 Different columns
I want duplicate stocks to be printed
I want unique stocks to be printed
Also Lets say I would like price columns to be picked up with stock name
Example
Stock list 1
HCL
ICICI
ITC
ZEE
COLPAL
INFY
TCS
HDFC
Britannia
Stock List 2
HCL
ICICI
ITC
ZEE
COLPAL
INFY
axy
xyz
abc
TCS
HDFC
Britannia
I want duplicate stocks to be printed
I want unique stocks to be printed
Also Lets say I would like price columns to be picked up with stock name
Example
Stock list 1
HCL
ICICI
ITC
ZEE
COLPAL
INFY
TCS
HDFC
Britannia
Stock List 2
HCL
ICICI
ITC
ZEE
COLPAL
INFY
axy
xyz
abc
TCS
HDFC
Britannia