Sort From Highest to Lowest

[kumara_faith]

Hi,

I have the following input table:

Expense Tracker_Test.xlsx
	B	C	D
7	Date	Expense	Amount (INR)
8	Saturday, 29 October, 2022	Incense	500
9	Sunday, 30 October, 2022	Biscuit	300
10	Sunday, 30 October, 2022	Book	200
11	Tuesday, 1 November, 2022	Breakfast	100
12	Wednesday, 2 November, 2022	Internet	200
13	Saturday, 5 November, 2022	Donation	600
Expense Journal

Cells with Data Validation
Cell	Allow	Criteria
B8:B356	List	=Date
C8:C470	List	=Expense1

On another sheet, I am trying to summarize the expenses based on category and by highest amount to lowest automatically as the expenses details are being entered:

Expense Tracker_Test.xlsx
	B	C	D
2	Expense Category	Amount RM	Amount INR
3	Biscuit	300	17
4	Book	200	11
5	Breakfast	100	6
6	Donation	600	34
7	Incense	500	28
8	Internet	200	11
Summary

Cell Formulas
Range	Formula
B3:B8	B3	=SORT(UNIQUE(FILTER('Expense Journal'!C8:C362,'Expense Journal'!C8:C362<>"")))
C3:C8	C3	=IF(B3=0,"",SUMIF('Expense Journal'!$C$8:$C$350,Summary!B3,'Expense Journal'!$D$8:$D$350))
D3:D8	D3	=IF(B3=0,"",SUMIF('Expense Journal'!$C$8:$C$350,Summary!B3,'Expense Journal'!$E$8:$E$350))
Dynamic array formulas.

However, as per the table above, the amount is not sorted by highest to lowest automatically. Is there a way to accomplish this ?

 

[etaf]

sort('Expense Journal'!C8:D362,2,-1)

where the amount INR come from

Book2
	A	B	C	D	E	F
1	Date	Expense	Amount (INR)
2	44863	Incense	500		Donation	600
3	44864	Biscuit	300		Incense	500
4	44864	Book	200		Biscuit	300
5	44866	Breakfast	100		Book	200
6	44867	Internet	200		Internet	200
7	44870	Donation	600		Breakfast	100
Sheet1

Cell Formulas
Range	Formula
E2:F7	E2	=SORT(B2:C7,2,-1)
Dynamic array formulas.

 

[kumara_faith]

Hi etaf,

Thank you.

Is there a way to accomplish the result by referencing directly the first table (the expense input table) instead of the second table (summary table) ?

 

[etaf]

sorry, not sure what you mean the tables look similar
i used expense journal -

and kepp in same sheet for simplcity - but you can add a sheet name

 

[kumara_faith]

Hi etaf,

My apologies. The solution worked. Thank you for your patience and have a great day ahead.

 

[etaf]

you are welcome