Auto generation of 3 levels of running number

H

hamiraj

I am currently working on a spreadsheet that should allow me to have a
running number of a task (T), sub task (ST) and sub sub task (SST). For
instance, for T1 consists of 3 ST. ST1 has 2 SST, and ST3 has 3 SST. T2
has only 2 ST.T2 consists of 2 ST with 2SST each.

For simplification, the following is the scenario:
T1 T2
ST1 ST2 ST3 ST1 ST2
SST1 SST2 SST1 SST2 SST3 SST1 SST2 SST1 SST2

I would like for T to be assigned with a numerical value e.g. 1,2,3 with
the ST having 1 decimal place (dp) no. e.g. 1.1, 1.2, 3.1,3.2,3.3 and SST
having a 2 dp no. 1.1.1, 1.2.1 etc.

How can I do it in excel?

Thanks for your help.

HAMIRAJ FAHRY
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto generation of 3 levels of running number 1
lookup two arguments 4
Auto populate value from one task to another in MS PROJECT 0
Task Usage view at a Summary Task Level 2
Macro to Lookup Exact Value 3
Merge records with same number 0
VBA vs C#: filling a spreadsheet with random numbers - C# 4x slower... 5
Parameter queries with multiple parameters and null values 5

Top