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 .