Filter showing Activities with +/- lag !

Hi all.

For those who are familiar with SQL - the most attractive solution for above mentioned routines is MSAccess or any other DB oriented program. The export should be therefore done in DBF.

Regards

Andrew

Deepak



I mean using the export function in P3, It export a wks file that you can either open in Lotus 123 or excel.



Like Ronald said, you can easily to achieve to filter the 2500 activity with lag. (Its a 2 second job - and no need to do it manually, use auto fileter. and with a custom condition Lag <> 0)



Once you produce this list you might have a duplicate activity id.



What you can do then is to use another excel funtion, to create the unique list.



If you have difficult in Excel, then I suggest you better learn in quickly, because we(planner) do require a lot of the excel skill to create reports.



Good Luck



Alex

Step 2 is simply done in Excell. Select all and sort by lag column. Highlight the middle rows without a lag and delete.

Deepak



The quick answer is no



but you can still do it with the following steps



1. export all relationship in P3

2. filter the activity have +/- Lag

3. Create a unique list using excel funtion

4. import this list with a special project code

5. use this code to filter these activity

6. remember to use this code to assign new relationship that have lags attached



HTH



Alex