Home

Find next Item number and Product in set of data

%3CLINGO-SUB%20id%3D%22lingo-sub-801999%22%20slang%3D%22en-US%22%3EFind%20next%20Item%20number%20and%20Product%20in%20set%20of%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-801999%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20project%20which%20will%20contain%20a%20list%20of%20tasks%20to%20be%20completed%2C%20which%20will%20be%20constantly%20being%20updated.%20I%20will%20to%20have%20a%20summary%20that%20will%20track%20the%20item%20and%20product%20for%20each%2C%20and%20have%20as%20a%20table%20to%20mark%20as%20completed%20as%20we%20progress.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20hoping%20to%20have%20a%20formula%20to%20find%20the%20next%20task%20item%2C%20and%20then%20populate%20the%20one%20copy%20of%20each%20for%20each%20product.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20an%20example%2C%20which%20i%20am%20to%20do%20the%20following%3A%3C%2FP%3E%3CP%3E1.%20As%20as%20task%20is%20added%20to%20the%20last%20list%20on%20the%20%22list%20of%20tasks%20tab%22%2C%20I%20want%20a%20row%20to%20populate%20for%20each%20fund%20so%20I%20can%20then%20track%20and%20monitor%20as%20each%20is%20completed.%3C%2FP%3E%3CP%3E2.%20I%20then%20wish%20to%20show%20the%20fund%20name%20for%20each%20task%20row%2C%20so%20that%20the%20owner%20of%20each%20can%20find%20and%20update.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20assist.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-801999%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
calof1
Contributor

Hi,

 

I have a project which will contain a list of tasks to be completed, which will be constantly being updated. I will to have a summary that will track the item and product for each, and have as a table to mark as completed as we progress. 

 

I am hoping to have a formula to find the next task item, and then populate the one copy of each for each product.

 

Attached is an example, which i am to do the following:

1. As as task is added to the last list on the "list of tasks tab", I want a row to populate for each fund so I can then track and monitor as each is completed.

2. I then wish to show the fund name for each task row, so that the owner of each can find and update.

 

Can someone please assist.

 

Kind regards,

Related Conversations