Hello everyone, hope someone can help me with the following:
I want to match below table 1 and 2 and display like the expected result table. Can it be done using excel formula or macro? or it can only to be done manually?
Table 1
DATE DESC AMOUNT
1-Jan-17 AAAA 100,000.00
Table 2
DATE DESC AMOUNT
1/2/2017 AAAA 50,000.00
1/5/2017 KKKK 90.00
1/6/2017 AAAA 50,000.00
Expected Result
DATE DESC AMOUNT DATE DESC AMOUNT
1-Jan-17 AAAA 100,000.00 1/2/2017 AAAA 50,000.001/6/2017 AAAA 50,000.00
Bookmarks