Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit a template from normal user activity | Excel Discussion (Misc queries) | |||
Chart for company activity/pinchpoints | Charts and Charting in Excel | |||
Running Activity Chart | Charts and Charting in Excel | |||
Template for Activity Log with Sorting Capabilities | Excel Discussion (Misc queries) | |||
Display material and activity | Excel Worksheet Functions |