Finding and arranging rows then displaying their frequency in descending order:

Hi,

There are two Groups of Data:

GROUP A

From A TO D there are initial values.

A1    B1    C1    D1
19    18    16    12
4     9     30    18
19    18    16    12
43    5     40    18
19    18    16    12
4     9     30    18
6     7     12    41
15    21    18    40
43    5     40    18
43    5     40    18
43    5     40    18
6     7     12    41
6     7     12    41
5     19    30    25

From E TO H there are values which have occured more than once.

E1    F1    G1    H1
19    18    16    12
4     9     30    18
43    5     40    18
6     7     12    41

For Group A there are 2 tasks to be completed.

The first task is to arrange the rows in E TO H according to the number of times it has occured at A TO D in descending order as followes:

I1    J1    K1    L1
43    5     40    18
19    18    16    12
6     7     12    41
4     9     30    18

As "43,5,40,18" has occurred the maximum number of times which is 4 times so it is on top then follows "19,18,16,12" & "6,7,12,41 as they have occurred 3 times each, then there is "4,9,30,18"
at the bottom because it has occurred the minimum number of times which is 2 times.

The second task is to display the frequency of each rows From I TO L at M as follows:

M1
4
3
3
2

AS "43,5,40,18" has occurred 4 times in A TO D there is 4 at M1, "19,18,16,12" and "6,7,12,41" has occurred 3 times each in A TO D there is 3 at M2 and M3 respectively, then "4,9,30,18" has
occurred 2 times in A TO D there is 2 at M4.


GROUP B

From N TO P there are initial values.

N1    O1    P1    
19    18    16    
4     9     30    
19    18    16    
43    5     40    
19    18    16    
4     9     30    
6     7     12    
15    21    18    
43    5     40    
43    5     40    
43    5     40    
6     7     12    
6     7     12    
5     19    30

From Q TO S there are values which have occured more than once.

Q1    R1    S1    
19    18    16    
4     9     30   
43    5     40    
6     7     12

For Group B there are 2 tasks to be completed same as in Group A.

The first task is to arrange the rows in Q TO S according to the number of times it has occurred at N TO P in descending order as follows:

T1    U1    V1    
43    5     40    
19    18    16    
6     7     12    
4     9     30

As "43,5,40" has occurred the maximum number of times which is 4 times so it is on top then follows "19,18,16" & "6,7,12 as they have occurred 3 times each, then there is "4,9,30"
at the bottom because it has occured the minimum number of times which is 2 times.

The second task is to display the frequency of each rows From T TO V at W as follows:

W1
4
3
3
2

AS "43,5,40" has occurred 4 times in N TO P there is 4 at W1, "19,18,16" and "6,7,12" has occured 3 times each in N TO P so there is 3 at W2 and W3 respectively, then "4,9,30" has
occured 2 times in N TO P there is 2 at W4.

Thank you so much for your admirable support.