Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have set of data in two columns. This data should get segregated in
different tables which will further be used for plotting graphs (depending on the number of tables the data is segregated/ sorted in. The data is like this: 1-2, 2-3, 3-4, 4-5, 4-6,6-7. Here note that the first number is in one column and second in another. data in other columnns is associated with set of these ftwo columns. If u observe the data, the chain breaks at node 4 where there is branching from 4 to 5 and 4 to 6. in another branch the chain continues from 6-7. Now I need to end one chain from 1---4-5 and another chain from 1----4-6-7. This should be generated in two (as number of branches are 2) tables. Two graphs will be generated based on these two tables. pl. suggest a macro for this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert full row from worksheer to another base on condition | Excel Discussion (Misc queries) | |||
Split table into smaller tables & into different worksheets each | Excel Worksheet Functions | |||
sum top 5 base on one condition | Excel Worksheet Functions | |||
sum of top 5 base on one condition | Excel Worksheet Functions | |||
Addition base on condition | Excel Worksheet Functions |