kehsihba55
New Member
- Joined
- Nov 4, 2014
- Messages
- 1
Hi,
I am a vivid reader of this forum. I am struggling with the below scenario. Your help is gonna save lot of manual work. Thanks in advance.
Below are two sheets in my excel.
Sheet1
Col1(obj) Col2 (Trade Date)
ob1 2014-20-01
ob1 2014-21-01
ob1 2014-24-01
ob2 2014-20-01
ob2 2014-22-01
ob2 2014-23-01
ob3 2014-24-01
Sheet2
Col1 1(All trade dates exceluding weekends and holidays)
2014-01-20
2014-01-21
2014-01-22
.....
2014-12-29
2014-12-30
2014-12-31
I want to find out for each object which all trade date is missing.(when compared to All trade dates in sheet2 )
So I am expecting an output as below in new sheet.
Sheet3
Col1 (obj) Col2 (Missing Dates)
obj1 2014-22-01
obj1 2014-23-01
obj2 2014-21-01
obj2 2014-24-01
Obj3 2014-20-01
...... ...........
Please help me out.
Thanks,
Abhishek
I am a vivid reader of this forum. I am struggling with the below scenario. Your help is gonna save lot of manual work. Thanks in advance.
Below are two sheets in my excel.
Sheet1
Col1(obj) Col2 (Trade Date)
ob1 2014-20-01
ob1 2014-21-01
ob1 2014-24-01
ob2 2014-20-01
ob2 2014-22-01
ob2 2014-23-01
ob3 2014-24-01
Sheet2
Col1 1(All trade dates exceluding weekends and holidays)
2014-01-20
2014-01-21
2014-01-22
.....
2014-12-29
2014-12-30
2014-12-31
I want to find out for each object which all trade date is missing.(when compared to All trade dates in sheet2 )
So I am expecting an output as below in new sheet.
Sheet3
Col1 (obj) Col2 (Missing Dates)
obj1 2014-22-01
obj1 2014-23-01
obj2 2014-21-01
obj2 2014-24-01
Obj3 2014-20-01
...... ...........
Please help me out.
Thanks,
Abhishek