April 30, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Keeping Total row at the bottom, groupby wrapped with sort

I have a formula that is a groupby wrapped with sort:

=SORT(GROUPBY(...),8,-1)

Since I'm sorting my totals column by descending, it's bringing the totals row to the top. Is there any way to keep it at the bottom?

Check out the full article on the original site

#row zero

#rows.com

#financial modeling with spreadsheets

#AI formula generation techniques

#Excel compatibility

#Excel alternatives for data analysis

#formula generator

#Excel alternatives

#SORT

#GROUPBY

#totals

#descending

#formula

#row

#column

#data

#Excel

#aggregate

#ranking

#summation