Thanks @ComplexPoint but this seems to be a bit over my head and I keep getting a blank display window 
This is where I am at. I can make the list to include Variable D as seen in the macro below. I have tried cobbling together the actions from the macro created by @JMichaelTX in this thread....
but as I would expect when I add another part to each line, that being the new Variable D, and and go from
VariableA, VariableB, VariableC
SK BDC ,178554794,178964282
to
VariableA, VariableB, VariableC, VariableD
SK BDC ,178554794,178964282,409488
it throws off the macro and the groups are not created correctly. I think there is a simple tweak in there I am not getting that would find and organize each group as the original macro by @JMichaelTX intended. That would be the first step. The second step would be adding the Variable D together for each of those groups and I imagine creating a new list with each line consisting of Variable A and the sum of variable Ds for that particular group.
This is a very simplified example but it would take a group like this...
SK BDC ,5,15,10
SK BDC ,20,30,10
SK BDC ,40,50,10
SK BDC ,60,70,10
SK BDC ,80,90,10
and the macro would then make that group into one line that was the sum of VariableD to look like...
SK BDC ,50
and of course make that single line with each group name (Variable A) with the sums of Variable D for each particular group set.
With the final step being a numerical ordering from highest Variable D to lowest Variable D
