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
Excel Formula Help....
shardae in Excel on
0 Replies
Mac/Excel
Kayla_Carter in Excel on
0 Replies
HELP! I can't "unhide" my rows
Twobizzy515 in Excel on
1 Replies
Issue with graphics on Excel
Theophile1615 in Excel on
3 Replies