INDEX, MATCH, LARGE and/or SUMIF/SUMPRODUCT

[bsquad]

I am looking for a formula that will assist in the last two columns


-the first two columns is the raw data
-the third and fourth columns is a distinct for the class name and a sumproduct
-the last two is an Index/match/large

I am looking for an all in one formula and haven't gotten any. I have also searched all over the place and cannot seem to find such a combination.

Class	Values
Class 1	4		Class 1	6		Class 10	987
Class 2	3		Class 2	836		Class 2	836
Class 3	65		Class 3	83		Class 4	285
Class 4	2		Class 4	285		Class 3	83
Class 5	13		Class 5	13		Class 13	44
Class 3	3		Class 6	36		Class 12	41
Class 6	11		Class 7	30		Class 6	36
Class 7	23		Class 8	2		Class 7	30
Class 3	15		Class 9	12		Class 15	18
Class 4	3		Class 10	987		Class 5	13
Class 7	7		Class 11	1		Class 9	12
Class 4	5		Class 12	41		Class 9	12
Class 2	100		Class 13	44		Class 14	11
Class 8	2		Class 14	11		Class 1	6
Class 4	8		Class 15	18		Class 18	4
Class 4	267		Class 16	12		Class 17	3
Class 9	12		Class 17	3		Class 8	2
Class 10	800		Class 18	4		Class 8	2
Class 11	1		Class 19	2		Class 11	1
Class 10	15
Class 2	722
Class 10	54
Class 1	2
Class 10
Class 10	13
Class 12	41
Class 10	42
Class 10	17
Class 13	17
Class 10	3
Class 10	12
Class 14	11
Class 15	6
Class 10	17
Class 10	11
Class 16	12
Class 17	3
Class 10	3
Class 2	11
Class 18	4
Class 6	11
Class 6	11
Class 13	27
Class 6	3
Class 19	2
Class 15	12

<tbody>
</tbody>

 

[CyrusTheVirus]

So basically you are trying to bring six columns down to four, is that correct?

And you want to accomplish this by a formula that will sum all values for each class, then sort from largest to smallest, correct?

 

[Brian from Maui]

You can use a Pivot Table

 

[FDibbins]

I am looking for an all in one formula and haven't gotten any.

Why? I have found that more often than not, when faced with a complex problem like this, it is better to break it down the way you have. Even if there was a formula to do all that in 1 go, it would probably be so complex as to make troubleshooting or adjusting a big problem

 

[FDibbins]

You can use a Pivot Table

Perhaps explain how?