PC Review


Reply
Thread Tools Rate Thread

compare and grouped it.

 
 
New Member
Join Date: May 2011
Posts: 1
 
      26th May 2011
hi ,
i have a table which have values like this :

Sub A Sub B Sub C Sub D
Sub A 0 0 1 0
Sub B 0 0 0 1
Sub C 1 0 0 1
Sub D 0 1 1 0

i want to compare columns and rows and assign color to Sub A, B , C and D and group it using graph coloring method. the value 0 means both 2 sub are connected and if 1 its not connected. If the value is 0 the color between those to sub must be different and if 1 can be same color but have to make sure the color not had been assigned to other sub which are already connected to itself. in this example the subs will be assigned with 2 colors which means 2 groups. Sub A - red, Sub C -red, Sub B - blue and Sub D- blue. Sub B and D not connected so it can be in same color. and same goes to Sub A and C. the final output should be in a table like this:

Column 1(red) Column 2(blue)
Sub A Sub B
Sub C Sub D

it has to be implemented in vb code. anyone please help me for the solution.
thanks.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare sheet utility that can compare formula too Adam2046 Microsoft Excel Discussion 3 27th Apr 2010 09:26 AM
Grouped Items won't Stay Grouped When Moving Object Heather02 Microsoft Excel Misc 0 12th Feb 2009 07:08 PM
How do I compare cells and if FALSE compare to next cell in EXCEL =?Utf-8?B?Q2luZGll?= Microsoft Excel Worksheet Functions 0 24th Mar 2006 05:29 PM
Sorting Grouped & Non-grouped Rows W.Gidzinski Microsoft Excel Misc 1 10th Oct 2003 12:34 AM
compare data from one column with another and compare result to yet another Matt Williamson Microsoft Excel Worksheet Functions 1 25th Sep 2003 08:54 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:02 AM.