I have two columns - one is with project number, another one is with sub-numbers (included in project). What I would like to do is to create a "smart offset" - so if there is a project number, I don't want to see sub-number. I want to see sub numbers in rows below, etc.
What I have now is following: =IF(A14=A13,"",A15) =IF(E15<>"","",IF(E14<>"",B14,B15))
However, it doesn't work perfectly - it keeps missing the milestone (sub-project) on a row with the project (initiative) number.
I have attached the picture, because it's hard to explain.
I'm fine with adding extra columns if that is going to help.
thank you for help, Marek
Aucun commentaire:
Enregistrer un commentaire