Home

Help to find next task number in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-805911%22%20slang%3D%22en-US%22%3EHelp%20to%20find%20next%20task%20number%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-805911%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20projects%2C%20which%20also%20contain%20project%2C%20and%20subtasks%20for%20each%20job.%20I%20wish%20to%20find%20the%20next%20project%20item%20number%2C%20and%20swap%20projects%20when%20the%20list%20of%20subtasks%20is%20complete.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20an%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20assist.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-805911%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent 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.

Related Conversations
Can I use wildcards with the new FILTER function
StuLux23 in Excel on
4 Replies
Please guide
Amardeep1001 in Excel on
0 Replies
freeze panes, freezes more than I select
jhaynie in Excel on
1 Replies
Power Query/Pivot - Hours not in chronological order
Shahria3 in Excel on
1 Replies
How to add scale breaks in an Excel graph?
Ruben805 in Excel on
3 Replies
Tabellenbereich dynamisch erweitern oder reduzieren?
TheSoulrester in Excel on
0 Replies