How to sort Monthly budget sheet by budgeted amount

Google Sheets
1

Hello,
I would like to sort the monthly budget sheet such that the highest budgeted amount is first, rather than in alphabetical order. I tried modifying another post that sorted by amount spent but couldn’t quite get the scripting just right. Thanks!

2

I believe you are referring to this other post.

Modifying what was suggested there, how about this for sorting by budget amount?

Monthly Budget sheet, cell Q16 :

={query(
   {INDIRECT(K21),INDIRECT(K20),INDIRECT(K19),INDIRECT(K22),ARRAYFORMULA(XLOOKUP(INDIRECT(K19),Z16:Z,AA16:AA,0,0,1))},
   "select Col1, Col2, Col3 where Col1 = 'Income' and Col4 <> 'Hide' order by Col2 asc, Col5 desc, Col3 asc",0);
  query(
   {INDIRECT(K21),INDIRECT(K20),INDIRECT(K19),INDIRECT(K22),ARRAYFORMULA(XLOOKUP(INDIRECT(K19),Z16:Z,AA16:AA,0,0,1))},
   "select Col1, Col2, Col3 where Col1 = 'Expense' and Col4 <> 'Hide' order by Col2 asc, Col5 desc, Col3 asc",0)}
2 Likes
3

Thanks for the quick solve, @Mark.S. Did this work for you, @tAMG20?

Remember that if you restore or update the Monthly Budget this (and other) formula modifications will be overwritten.

2 Likes
4

This worked great, thank you!!

2 Likes