activity duration
I have data in following format in excel
IDATE PNAME STATUS RL SDATE DIFF 13/08/2006 HOC AT Y 13/08/2006 13/08/2006 HOC AG Y 23/08/2006 13/08/2006 HOC AG H 24/08/2006 13/08/2006 HOC UP Y 27/08/2006 13/08/2006 HOC FILE H 30/08/2006 SUM HOC-STAT I m not good in macro therefore looking for help. Actually what i m trying to do that where the PNAME is same in above data it should subtract SDATE-IDATE and depict the value in DIFF col (days). secondly it should have running difference for PNAME for each row. and count the bigger value if it encountered STATUS and PNAME is same however SDATE is different. Last sum DIFF for each row and shows in next row called sum HOC-STAT. I have 1800 PNAME to do this plz help. jd |
activity duration
SDATE? HOC? STAT? You're talking about a lot of things that aren't
referenced here. "-jawad" wrote: I have data in following format in excel IDATE PNAME STATUS RL SDATE DIFF 13/08/2006 HOC AT Y 13/08/2006 13/08/2006 HOC AG Y 23/08/2006 13/08/2006 HOC AG H 24/08/2006 13/08/2006 HOC UP Y 27/08/2006 13/08/2006 HOC FILE H 30/08/2006 SUM HOC-STAT I m not good in macro therefore looking for help. Actually what i m trying to do that where the PNAME is same in above data it should subtract SDATE-IDATE and depict the value in DIFF col (days). secondly it should have running difference for PNAME for each row. and count the bigger value if it encountered STATUS and PNAME is same however SDATE is different. Last sum DIFF for each row and shows in next row called sum HOC-STAT. I have 1800 PNAME to do this plz help. jd |
All times are GMT +1. The time now is 04:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com