riyajuiptech
New Member
- Joined
- Feb 24, 2014
- Messages
- 2
Hi
I'm having following Excel Table for two category of Phases.
Phase 1
Date Pur.Value Tax
01/02/2014 1000.00 10.00
01/02/2014 500.00 5.00
02/02/2014 1500.00 15.00
22/02/2014 7000.00 70.00
Phase 2
Date Pur.Value Tax
01/02/2014 5000.00 50.00
01/02/2014 510.00 5.10
02/02/2014 7500.00 75.00
22/02/2014 4300.00 43.00
In above, I need in another Sheet for Calculation based on Date and Category.
Eg Report
Phase 01
01/02/2014 1500.00 15.00
02/02/2014 1500.00 15.00
22/02/2014 7000.00 70.00
Phase 02
01/02/2014 5510.00 55.10
02/02/2014 7500.00 75.00
22/02/2014 4300.00 43.00
How Can I do for this using Date Function?
I'm having following Excel Table for two category of Phases.
Phase 1
Date Pur.Value Tax
01/02/2014 1000.00 10.00
01/02/2014 500.00 5.00
02/02/2014 1500.00 15.00
22/02/2014 7000.00 70.00
Phase 2
Date Pur.Value Tax
01/02/2014 5000.00 50.00
01/02/2014 510.00 5.10
02/02/2014 7500.00 75.00
22/02/2014 4300.00 43.00
In above, I need in another Sheet for Calculation based on Date and Category.
Eg Report
Phase 01
01/02/2014 1500.00 15.00
02/02/2014 1500.00 15.00
22/02/2014 7000.00 70.00
Phase 02
01/02/2014 5510.00 55.10
02/02/2014 7500.00 75.00
22/02/2014 4300.00 43.00
How Can I do for this using Date Function?
