2 columns contains data like 1,2 and 2,3 now I want output as 1,3 in new sheet
But these are are not restricted only 2 levels, I mean there may be some more like
1,2
2,3
3,4
7,9
9,2
10,11
11,12
Now I want the output like this
1,4 bcoz 1-->2,2-->3,3-->4 and where 4 doesnt have next level.
2,4 bcoz 2-->3,3-->4 and where 4 doesnt have next level.
3,4 bcoz 3-->4 and where 4 doesnt have next level.
7,4 bcoz 7-->9, 9-->2,2-->3,3--4, and where 4 doesnt have next level.
9,4 bcoz 9-->2,2-->3,3--4, and where 4 doesnt have next level.
10,12 bcoz 10-->11,11-->12 and where 12 doesnt have next level.
11,12 bcoz 11-->12 and where 12 doesnt have next level.
Please help me out, I am stuck. I am using MS excel 2003 and any solution is highly appreciated.
Bookmarks