+ Reply to Thread
Results 1 to 7 of 7

2 columns contains data like 1,2 and 2,3 now I want output as 1,3 in new sheet

  1. #1
    Registered User
    Join Date
    11-17-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    4

    2 columns contains data like 1,2 and 2,3 now I want output as 1,3 in new sheet

    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.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: 2 columns contains data like 1,2 and 2,3 now I want output as 1,3 in new sheet

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

  3. #3
    Registered User
    Join Date
    11-17-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: 2 columns contains data like 1,2 and 2,3 now I want output as 1,3 in new sheet

    HI davesexcel,

    I am having production database, So I cant share you the data.. Please try to help me..

  4. #4
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465

    Re: 2 columns contains data like 1,2 and 2,3 now I want output as 1,3 in new sheet

    Hi,

    Can you please let me know what is that sequence is for.

    like I understand :-
    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.

    ----------
    But what is
    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.
    __________________
    Regards
    Rahul Nagar
    Founder of www.myshortcutkeys.com.


    If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
    Also
    If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.

  5. #5
    Registered User
    Join Date
    11-17-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: 2 columns contains data like 1,2 and 2,3 now I want output as 1,3 in new sheet

    HI,

    Actually the first column is id of the employee and 2nd column is manage id.
    7,4 bcoz 7-->9, 9-->2,2-->3,3--4, and where 4 doesnt have next level.
    So for the employee 7, 9 is the manager of 7 and 2 is manager for 9 and 3 is manager of 2 and 4 is manager of 3..and 4 has no manager..So in this hirerachy 4 is the highest level of manager for 7.
    SO I want the output of 7,4 i.e for 7 employee, manager 4 is the highest level of manager
    Like this I want for each and every employee in column A.

    Hope this understands more clearly.

    Thanks..
    Last edited by vamsicoolman; 11-18-2010 at 02:46 AM.

  6. #6
    Valued Forum Contributor Rahul Nagar's Avatar
    Join Date
    09-18-2008
    Location
    nasik
    MS-Off Ver
    Excel 2003
    Posts
    465

    Re: 2 columns contains data like 1,2 and 2,3 now I want output as 1,3 in new sheet

    It’s very confusing… 
    Can you please attached sample (only example not your actual data) file for more details.
    with what result you want.

  7. #7
    Registered User
    Join Date
    11-17-2010
    Location
    Hyderabad
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: 2 columns contains data like 1,2 and 2,3 now I want output as 1,3 in new sheet

    Please check the attachment and see the explanation below..


    If you see the flow of the data..employee 435676 is having the manager 433854 and manager of 433854 is 433636(see the second row of data) and 433636 is having 350335 is manager and 350335 is having300054 as the manager. So 300054 is highest manaher of first employee 435676 So output of should be 435676 , 300054 ..
    In the same maner I want to check for each row highest manager..

    Thank you..
    Attached Files Attached Files
    Last edited by vamsicoolman; 11-18-2010 at 05:14 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1