Help to find next task number in excel

Iron Contributor

Hi,

 

I have a list of projects, which also contain project, and subtasks for each job. I wish to find the next project item number, and swap projects when the list of subtasks is complete.

 

I have attached an example.

 

Can someone please assist.

0 Replies