Group sum based on the Location, but in increasing order.

[vasu2007]

Hello Experts,

I need to sum the numbers in col "B" based on the locations in Col "A", but is in increasing order.

COL#A COL#B
A - 1
A - 1
B - 2
B - 1
C - 3
C - 1

OUT PUT:
C(4)+B(3)+A(2) = 9

C+B+A should be in ascending order based on the sum in column B. This is the tricky part.
I have searched for this kind of requirement, but unable to find

Data & output is given in Below Picture.

Please help. Thanks in advance.

Consolidate.xlsx
	A	B	C	D	E	F	G	H
1	Location	Value			OUTPUT	SL NO	LOCATION	Sum
2	A	1				1	B+A+C	17.5
3	C	0.8				2	A+B+D+C	49.9
4	A	4.7				3	A+D+B+C	65.9
5	B	11
6		17.5
7	D	1.3
8	D	4.5
9	C	4.8
10	A	31.4
11	B	4.9
12	B	1.3
13	B	1.7
14		49.9
15	C	4.5
16	C	0.7
17	B	15.9
18	D	3.7
19	D	2.2
20	D	14.8
21	A	24.1
22		65.9
Sheet1

 

[Joe4]

Duplicate to: Group sum based on the Ascending order of the number

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.