Grouping rows in excel , these rows heaving matches values in either columns A or B

  • Grouping rows in excel , these rows heaving matches values in either columns A or B, for example


    Column A ; Columns B ; Column C


    1) A_22 ; A_21; Car
    2) A_23 ; A_41; Table
    3) A_21 ; A_50; Man
    4) A_41;A_60; Pen
    5) A_10;A_60 ; Chair
    6) A_22;A_75 ; Key
    7) A_11;A_12 ; Watch


    The function will search for match value of Column A row 1 (A_22) in both columns A and B from row 2 to row 7 after finding matche , which is in row 6 column A again to search for match the value of row 6 but column B (A_75) from row 2 to row 7 , for the given example no match will found, then will start search to match the value of row 1 but column B (A_21) with the same sequence performed with row 1 column A , which the match value will be in row 3 column A then again search for match the value of row 6 column B (A_50), no result will be found,


    Then the same sequence will be started with row no. 2 as no match found with row 1 or row 3 or row 6 then these group should be copy or cut the rows and past them in new excel sheet as follows ;


    Group 1
    1) A_22 ; A_21; Car
    3) A_21 ; A_50; Man
    6) A_22;A_75 ; Key


    Group 2
    2) A_23 ; A_41; Table
    4) A_41;A_60; Pen
    5) A_10;A_60 ; Chair


    Group 3
    7) A_11;A_12 ; Watch




    I tried to solve the above for long time by either access or excel program but I didn't succeed .

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!