LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
SNK SNK is offline
external usenet poster
 
Posts: 1
Default How do I split one table in multiple tables base on condition?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert full row from worksheer to another base on condition Ziyadh Excel Discussion (Misc queries) 1 February 5th 12 01:05 PM
Split table into smaller tables & into different worksheets each Pradeep Excel Worksheet Functions 8 May 9th 07 05:39 PM
sum top 5 base on one condition luvgreen Excel Worksheet Functions 2 June 28th 06 02:00 PM
sum of top 5 base on one condition luvgreen Excel Worksheet Functions 3 June 28th 06 05:51 AM
Addition base on condition 68magnolia71 Excel Worksheet Functions 4 April 15th 05 08:39 PM


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"