Good-evening, I have been searching for awhile now and I have not found a solution, so please forgive me if I have somehow missed it. I have a set of data as follows:

Col A = Group
Col B = # of Item A in the Group
Col C = # of Item B in the Group
Col D = total # in the Group
Col E = % of Item A in the Group

I would like to rank the Group by the number or Item A and then break ties with percentage of A in the Group.

If Group 3 and 4 came back with 3 of Item A, but respectively had a percentage content of 50% and 75% I would like Group 4 to rank higher.

I have tried several sum and averaging functions to no avail. Any suggestions? Very much appreciated!