1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Keeping Total row at the bottom, groupby wrapped with sort

Our take

When using a formula like =SORT(GROUPBY(...), 8, -1) to group and sort your data, it can be frustrating to see the totals row appear at the top instead of the desired bottom position. This issue arises because sorting by descending order places higher values first, pushing your totals up. To maintain the totals row at the bottom while still benefiting from the sorting functionality, consider adjusting your approach. Explore alternative methods to achieve your desired layout without sacrificing clarity or functionality.

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?

submitted by /u/JabroniTown
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with

#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