Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto generation of 3 levels of running number
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 Question: 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. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto generation of 3 levels of running number
You don't say (not that I understand) how the data would be structured, but
assuming task in column A, sub-task in column B, sub-sub-task in column C, you could use =SUMIF(A:A,T1) for task =SUMPRODUCT(--(A1:A1000=T1),--(B1:B1000=ST1),B1:B1000) for sub-task =SUMPRODUCT(--(A1:A1000=T1),--(B1:B1000=ST1),--(C1:C1000=SST1),C1:C1000) for sub-sub-task By putting T1,ST1,SST1 in cells you can compare against the cell rather than the value. -- HTH RP (remove nothere from the email address if mailing direct) "hamiraj" wrote in message lkaboutsoftware.com... 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 Question: 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. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Numbering certificate generation | Excel Discussion (Misc queries) | |||
Pivot Table For Running Inventory Levels | Excel Discussion (Misc queries) | |||
Automatic number generation. | Excel Discussion (Misc queries) | |||
Auto generation of 3 levels of running number | Excel Worksheet Functions | |||
Unique ID number generation | Excel Programming |