vendredi 22 février 2019

How to make a smart offset in excel?

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.

Example

enter image description here

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